Labels

Sunday, 1 May 2016

SQL DBA : My MSDB database is corrupted then how you will handle this scenario ?

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