April 19, 2011 at 12:32 am
If MSDB or ModelDB Fails shall we start the services or not? if any one know this please give me a solution
April 19, 2011 at 2:20 am
pavansqldba (4/19/2011)
If MSDB or ModelDB Fails shall we start the services or not? if any one know this please give me a solution
First, you need to find why it failed to start. Rebooting might not help. You need to find the cause. Go to event logs or SQL Server error log to find what actually has happened. Are the files being copied somewhere else. If yes, copy them back to their original location.
If there is some sort of corruption, you might want to start the SQL Server using T3608 flag which will just enable master and then if you have backups of system databases, restore them.
These methods should be worked upon only under a supervision of a DBA who knows what he is doing:-)
April 20, 2011 at 3:52 am
please provide full error information ( sqlserver errorlog )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply