恢复sql server的master库
首先进入单用户模式 sqlservr.exe -m恢复的顺序 master->msdb->model运行sqlcm...
扫描右侧二维码阅读全文
12
2009/10

恢复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的版本要一致

Last modification:November 26th, 2018 at 04:16 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment