Error attempting to detach a db 1

[daglugub37]

I got a db in ssuspect mode that I would like to detach\attach.

I get the following error when trying to detach.

---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Error 947: Error while closing database 'test_db' cleanly.
---------------------------
OK
---------------------------

 

[ptheriault]

you can't detach a database that is in suspect mode.
You will need to change the status then detach it.

EXEC sp_resetstatus ''

[COLOR=blue]EXEC[/color] sp_resetstatus [COLOR=red]'Your Db'[/color]

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[daglugub37]

thanks, I am all set