MSDB
Corrupt:
1)
Verify the reason of failure in the error logs and troubleshoot accordingly. If
database is really corrupt then look out for a available valid backup. If
backup is available restore MSDB as a normal user database and it would be
restored.
2) If
backup is not available, then stop the instance and start the instance in /m
and /t3608 startup parameters.
net
stop "SQL Server (MSSQLSERVER)"
net
start "SQL Server (instance name)" /t3608 /m
3)
Connect to the Query window and detach MSDB database and delete the OS level
files.
sp_detach_db
'MSDB'
NOTE: Remove MSDB data/log files manually from the path.
4)
Execute the script in %Root Directory%\Install\instMSDB.sql file.
No comments:
Post a Comment