![]() ![]() However, you can check the error log, as shown in the image below to verify the reason of corruption. Power surge is one such reason that compels the SQL server to reboot, but after the rebooting process the SQL server may not start in this scenario. There are various situations in which your master database can go corrupt or missing. Report generation by Database Consistency Checker Utility.ssibility of input/output errors or segmentation faults.How to Determine Whether Master Database Is Corrupt or Not?īeing a system administrator, it is important for you to know the symptoms that may indicate the corruption or damage in your master database. In brief, if anything happens to the master database, then you can’t start and productively work on your SQL server. This means the total user & login details, and the information of pointers to all the databases are stored on the master database. The core information of master database is recorded in a physical file, called MDF files, whereas the parallel transaction logs are stored on to the masterlog.ldf file. A Master Database is highly important for an SQL server, as it holds the primary configuration details of the SQL server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |