master database corruption in sql server

If SQL Server cannot read the boot page (or the minLSN value is not correct), the crash recovery cannot be made and the database cannot come online. Starting from this point, SQL Server writes the changes to the data files. This value represents the oldest uncommitted transaction at the point of a crash.

In this case, the boot page is read to get the minLSN value. SQL Server also accesses the boot page during the “redo” phase of the recovery process. SQL Server reads the boot page of every database when the instance starts and then logs an entry in the error logs writing when the last CHECKDB is run. Only one boot page exists for a database and is stored in page 9 in the first file in the primary filegroup. The boot page is a special page as it contains essential information about the database, such as the compatibility level, database ID, etc.

There are several types of corruption that can occur in an MS SQL Server database. In this post, we will see the different types of database corruption that can occur in the MS SQL Server database and the possible ways to resolve them.

Master database corruption in sql server