Put the shared disks into maintenance mode in failover cluster manager and run chkdsk “drive” /F /X on all of them. If a backup is not available, it might be necessary to rebuild the log.
Now that you know what message to look for, let’s see how to recover a master database.An error occurred while processing the log for database 'master'. If you check the error log ( Figure A), you’ll see that the master database is either corrupt or missing. Let’s pretend that your company had a power surge and your SQL Server rebooted. To demonstrate, I’ll break a master database to show you what happens if your master gets corrupted. How do you know if your master database is corrupt?īefore we discuss how to recover and rebuild your master database in the event of a failure, we need to look at how you can tell if it’s corrupt. I have been in many situations where it would have been easy to panic, but I’ve managed to weather the storm by remaining calm and following the proper methodology when dealing with a problem. That will help you follow a methodical approach when disaster strikes, rather than acting too quickly under pressure. It is important to have a plan for dealing with the corruption and/or failure of your master database. I’m going to walk you through the process of recovering the master database in the event of corruption and show you how to rebuild the master database, if necessary. Without the master database, you can’t successfully start SQL Server.
The master database stores your logins and, most importantly, the pointers to all of your databases. See how to recognize this event and learn the steps for recovering the master database using the Enterprise Manager and the Query Analyzer.Īs a Microsoft SQL Server administrator, you must know how to recover a corrupt master database. If the master database fails, Microsoft SQL Server can be brought to its knees. Recover the master database in SQL Server
0 kommentar(er)
