Sqlserver还原master

net stop mssqlserver
net start mssqlserver /m"SQLCMD"
sqlcmd -s xx 
sqlcmd -s xx -U sa -P xx
RESTORE DATABASE master FROM  DISK = N'E:\temp\master.bak' ,  MOVE N'masterData' TO N'E:\master.mdf',  MOVE N'masterLog' TO N'E:\mster.ldf'  with replace

参考资料:https://www.cnblogs.com/kerrycode/p/8727749.html

posted @ 2019-01-19 16:28  JinweiChang  阅读(152)  评论(0编辑  收藏  举报