SQL 2000 - randomly stopped - file permissions

have sql 2000 database instance 4 databases. 2 fine, 2 randomly stopped. detached and reattached them , in "read-only" mode , when try change them writable file permission errors: help/hints appreciated:

i know old customer has process require 2000 version.  on 1 reattahced in 2008r2 , 1 apparently cannot moved.

title: microsoft sql server management studio

------------------------------

alter failed database 'mydatabase'.  (microsoft.sqlserver.smo)

------------------------------
additional information:

exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)

------------------------------

device activation error. physical file name 'e:\mssql\data\mydatabase_data.mdf' may incorrect.
device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incorrect.
device activation error. physical file name 'f:\mssql\data\mydatabase_data_1' may incorrect.
device activation error. physical file name 'g:\mssql\data\mydatabase_data_2' may incorrect.
device activation error. physical file name 'g:\mssql\data\mydatabase_data_2' may incorrect.
device activation error. physical file name 'h:\mssql\data\mydatabase_data_3' may incorrect.
device activation error. physical file name 'h:\mssql\data\mydatabase_data_3' may incorrect.
device activation error. physical file name 'i:\mssql\data\mydatabase_data_4' may incorrect.
device activation error. physical file name 'i:\mssql\data\mydatabase_data_4' may incorrect.
device activation error. physical file name 'j:\mssql\data\mydatabase_data_5' may incorrect.
device activation error. physical file name 'j:\mssql\data\mydatabase_data_5' may incorrect.
device activation error. physical file name 'k:\mssql\data\mydatabase_data_6' may incorrect.
device activation error. physical file name 'k:\mssql\data\mydatabase_data_6' may incorrect.
device activation error. physical file name 'l:\mssql\data\mydatabase_data_7' may incorrect.
device activation error. physical file name 'l:\mssql\data\mydatabase_data_7' may incorrect.
device activation error. physical file name 'm:\mssql\data\mydatabase_data_8' may incorrect.
device activation error. physical file name 'm:\mssql\data\mydatabase_data_8' may incorrect.
device activation error. physical file name 'n:\mssql\data\mydatabase_data_9' may incorrect.
device activation error. physical file name 'n:\mssql\data\mydatabase_data_9' may incorrect.
device activation error. physical file name 'q:\mssql\log\mydatabase_log.ldf' may incorrect.
device activation error. physical file name 'r:\mssql\log\mydatabase_log_1.ldf' may incorrect.
not restart database 'mydatabase'. reverting old status.
alter database statement failed.
device activation error. physical file name 'q:\mssql\log\mydatabase_log.ldf' may incorrect.
device activation error. physical file name 'r:\mssql\log\mydatabase_log_1.ldf' may incorrect. (microsoft sql server, error: 5105)

---

jb

so files exist on these paths?

right-click files, select security tab, advance button , there ownership tab, can change owner. make sure owner service account sql server.

if running , happens little green men in machine. or, more likely, process detaches files. check agent jobs , windows task scheduler.

---

erland sommarskog, sql server mvp, esquel@sommarskog.se

SQL Server  >  SQL Server Database Engine