ms db crash

Question

Post reply

ms db crash

anilr71

SSC Veteran

Points: 213
More actions
January 18, 2012 at 12:22 am

#391334

ms db crash
what we will do
how to restore ?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

anilr71 (1/18/2012)
ms db crash

What do you mean with "crash"? Database is suspect? The instance does not start? You found corruption with CHECKDB?

In order to restore the database you can issue a RESTORE DATABASE command.

-- Gianluca Sartori

vultar Hall of Fame Points: 3271 More actions · Answer 2

You will also need to stop the SQL agent if it's it still running.

Robert Murphy UK1 Default port Points: 1485 More actions · Answer 3

Have you tried a reboot? :w00t:

I think a lot more detail on the problem is needed in order to help you.

Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

vultar (1/18/2012)
You will also need to stop the SQL agent if it's it still running.

There's no need to. I would not recommend this (or anyhing else) until the OP comes back with more details.

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

Robert Murphy UK1 (1/18/2012)
Have you tried a reboot? :w00t:
I think a lot more detail on the problem is needed in order to help you.

No, please, don't reboot. Leave the instance online and take NO ACTION unless you know exactly the implications.

-- Gianluca Sartori

padhis SSCommitted Points: 1762 More actions · Answer 6

anilr71 (1/18/2012)
ms db crash
what we will do
how to restore ?

Do you have the backup of your msdb database?

Considerations for Restoring the model and msdb Databases :-

http://msdn.microsoft.com/en-us/library/ms190749.aspx

vultar Hall of Fame Points: 3271 More actions · Answer 7

vultar (1/18/2012)You will also need to stop the SQL agent if it's it still running.
There's no need to. I would not recommend this (or anyhing else) until the OP comes back with more details.

Sorry, I should have probably added that this needs to be done as part of the msdb restoration process..

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

vultar (1/18/2012)
vultar (1/18/2012)You will also need to stop the SQL agent if it's it still running.
There's no need to. I would not recommend this (or anyhing else) until the OP comes back with more details.
Sorry, I should have probably added that this needs to be done as part of the msdb restoration process..

That's assuming that MSDB has crashed, not an MS (Microsoft) DB

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

vultar Hall of Fame Points: 3271 More actions · Answer 9

That's assuming that MSDB has crashed, not an MS (Microsoft) DB

Good point.. I misread the original post! :blink: