March 17, 2012 at 11:01 am
After the server restart , one of the database is not coming online. any help to resolve
March 17, 2012 at 11:04 am
Database might be went in recovery pending state. check the error log as well for more information.
March 17, 2012 at 1:19 pm
Satya_0000 (3/17/2012)
After the server restart , one of the database is not coming online. any help to resolve
Put the database into emergency mode and run dbcc checkdb, post back the results.
Also, what is the recovery model of the database, do you have recent backups?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2012 at 2:56 pm
Before you do anything...
What is the exact state of the database (check state_desc in sys.databases)
What error message are there for the DB in the SQL error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply