November 2, 2007 at 6:34 am
Hi,
one of my DB is showing as "In recovery". Now i want to bring into back as an working mode(recovery mode).
any one can help me. in this issue.
Note : i don't have backup file
Regards,
Kishore KK.
November 2, 2007 at 7:08 am
you can use either of the below two options to get the database into recovery state
RESTORE DATABASE database_name
WITH NORECOVERY
OR
RESTORE LOG database_name
WITH NORECOVERY
November 2, 2007 at 7:13 am
did it go to the in recovery state after a service restart if so then your database is in recovery statte and ytou have to wait until it completes. this might have been caused if you have ran a huge transaction and aborting it in middle.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 2, 2007 at 7:38 am
sorry, its recovery instead of no recovery
-------------------------------------
you can use either of the below two options to get the database into recovery state
RESTORE DATABASE database_name
WITH RECOVERY
OR
RESTORE LOG database_name
WITH RECOVERY
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply