November 11, 2008 at 9:31 pm
Unable to start SQL server database engine has my MSDB databse has been deleted... Please let me know how can troubleshoot this???
November 11, 2008 at 9:46 pm
Hi,
May be you can try the following:
--> Start SQL service with trace flag -T3608 (which prevents SQL server from automatically starting and reovering any database except Master database).
--> Rebuild MSDB (in 2000 it is INSTMSDB.sql from service pack files; not sure in 2005)
[font="Verdana"]Renuka__[/font]
November 11, 2008 at 9:53 pm
First question I have, do you have a backup of the msdb database? If not, why not.
If you don't, start reading BOL (Books On-Line). You should be able to find instructions there on how to rebuild the system databases.
November 11, 2008 at 10:27 pm
thanks renuka it worked... instmsdb.sql script can be found in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
November 11, 2008 at 10:53 pm
You will have to re-create all your jobs, maintenance plans etc.
"Keep Trying"
November 12, 2008 at 12:33 am
Chirag (11/11/2008)
You will have to re-create all your jobs, maintenance plans etc.
And DTS packages and SSIS packages. You've also lost the backup history.
Now, go and set up a backup schedule for the system databases - master, model, msdb. Weekly is usually enough as they don't change often.
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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply