SQLSession60 | Fix MASTER Database Corruption in SQL Server Using 3 Methods
✅ Method 1 – Restore MASTER Backup in Single User Mode
Start SQL Server with startup parameters:
-m (Single User Mode)
-T3608 (Master Only Mode)
Update system database file locations if required.
Create a login and assign sysadmin privileges.
alter database [mssqlsystemresource] modify file (name='Data',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\mssqlsystemresource.mdf')
alter database [mssqlsystemresource] modify file (name='Log',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\mssqlsystemresource.ldf')
alter database [model] modify file (name='modeldev',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\model.mdf')
alter database [model] modify file (name='modellog',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\modellog.ldf')
alter database [msdb] modify file (name='MSDBData',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf')
alter database [msdb] modify file (name='MSDBLog',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf')
alter database [tempdb] modify file (name='tempdev',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\tempdb.mdf')
alter database [tempdb] modify file (name='templog',filename='C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\templog.ldf')
Restore the MASTER database using WITH REPLACE.
Remove startup parameters and restart the instance.
✅ Method 2 – Rebuild MASTER Database
When MASTER cannot start even with /m and /T3608, rebuild the system databases using SQL Server Setup.
Applicable for SQL Server 2005 through SQL Server 2025.
Important: Rebuilding MASTER also rebuilds MODEL and MSDB, so make sure you have backups of these databases.
Start SQL Server in single-user mode and restore MASTER using WITH REPLACE.
✅ Method 3 – Restore MASTER in Another Instance
Restore the MASTER backup in a separate SQL Server instance.
Detach and attach it as a copy.
Rename files appropriately and replace the corrupted MASTER database files.
Apply proper file permissions by referring to the MODEL database files.
Start SQL Server and verify the recovery.
This video is useful for:
SQL Server DBAs
Database Administrators preparing for disaster recovery
Interview preparation on SQL Server system databases
Troubleshooting MASTER database corruption
#SQLServer #MasterDatabase #DatabaseCorruption #DisasterRecovery #SQLDBA #SQLServer2022 #SQLServer2025 #MasterRecovery #DBA #SystemDatabases