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