1、以单用户模式启动及登录

2、retore

C:\Users\Administrator>sqlcmd -S WIN-M5JVQU0U9DT\MEP
1> RESTORE DATABASE master FROM DISK = 'C:\Users\Administrator\MSDATA.2\MSSQL11.MEP\MSSQL\Backup\master.bak' WITH REPLACE ;
2> go
Processed 424 pages for database 'master', file 'master' on file 1.
Processed 4 pages for database 'master', file 'mastlog' on file 1.
The master database has been successfully restored. Shutting down SQL Server.
SQL Server is terminating this process.
1>
  • No labels