恢复sql server的master库

林海缘

首先进入单用户模式
sqlservr.exe -m

恢复的顺序
master->msdb->model

运行sqlcmd
1>RESTORE DATABASE [master] FROM
DISK = N’G:\data\master.bak’ WITH FILE = 1,
NOUNLOAD, REPLACE, STATS = 10
2>GO

注意,sql server的版本要一致