Sunday, February 26, 2012

Databases in read-only

We have a client with several databases in read-only mode. When we try and take the dbs out of read-only, we get the path to the mdf files may be incorrect, which they are not. SQL 2000, SP3a. Has anybody seen this? The files themselves are not read-only, I gave the network services account full control and still nothing. The issue started when the client lost power, lasst week, the dbs came up suspect. Detach/Attach brought them back up in single user.

Any hep is appreciated.

What was the exact sequence of events after the power failure last week? What were the error log errors when the databases came back as suspect? Why did you/they attempt to detach/attach?

Can you post the T-SQL you're using, and the errors you get back?

Thanks

|||It turned out to be a permissions issue. The account used to start sql server didn't have the correct permissions on the data/log/mssql directories. They had changed domains and I don't think they new exactly what they were doing. I suspect the account was a domain admin before the domain change.

I used detach/attach because sp_resetstatus didn't take them out of suspect mode.

Thanks