My SQL Server Express database's
msdb file has become 'suspect'. All the other mdf files seem to be OK.
I now need to recreate the
msdb file, but I do not have a backup for it (guilty as charged!). I have backups for my other DBs. This is what I found from this blog:
If your msdb goes suspect then you have two choices, if you have backup of database then restore it else you have to recreate it
If you want to recreate it here are the steps to do it
- Start the server with trace flag 3608. Detach the damaged
- Navigate to the directory
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binnand start
sqlservr.exe -c -T3608
- Move or rename the damaged
- Go to the folder
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Installand run the
- Restart SQL Server without the 3608 trace flag
Has someone done this before? I would like to get opinions or better suggestions before I break things more.
EDIT: My advice to anyone is to treat SQL Express like any production DB. Have rigorous back-up policy and make sure you back-up your system databases.