March 10, 2014 at 10:36 pm
My msdb database is in suspect mode. i tried to recreate again msdb database from below link:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.abc\MSSQL\Install\instmsdb.sql.
bot not able to online .
March 10, 2014 at 10:42 pm
any errors in the logs?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2014 at 11:32 pm
in error logs error is missing disk drive but in my server all drives are showing.
even i checked sys event same error is showing and this is happen in yesterday night at 1:20 AM.
It may be possible Network fluctuation
Should i restart the server?
March 11, 2014 at 12:44 am
issue has been resolved after restart did below activity
1.First detach the suspect msdb database. You can't just detach msdb because you're not allowed to detach system databases. However, you can if you start the server with trace flag 3608. I did this by shutting down the server, navigating to the directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn' and doing the following: start sqlservr.exe -c -T3608
2.Move or rename the suspected msdb files (msdbdata.mdf and msdblog.ldf in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' directory)
3.Run the instmsdb.sql script in the 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install' directory
4.Shutdown and restart the server without the 3608 trace flag
when new MSDB online then restore latest backup from BACKUP repository
Thanks
Mahendra Shukla
March 11, 2014 at 7:32 am
Glad it is working
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply