SQL Server restores master database by rebuilding _mssql

SQL Server restores the master database by rebuilding the following details

1. Backup master Database

2. Stop service, delete master data file directly

3. Rebuild Master data file with Setup program

Access to the installation directory under the console.

d:\setup\sqlserver2012>setup/quiet/action=rebuilddatabase/instancename=sqlserver2012/sqlsysadminaccounts= username/sapwd= * * *

4. Single user mode to start SQL Server service, restore with backup files

Single-user mode boot: net start mssql$sqlserver2012/m

Sqlcmd Mode Connection: Sqlcmd-s "ServerName\InstanceName"

If there is no corruption in the master file itself, there is a master backup that requires only step 4 restore Master

5, restart the database service, after the normal access to

　

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.