sqlserver还原master和msdb

来源:互联网 发布:广州plc编程招聘信息 编辑:程序博客网 时间:2024/05/16 07:18
--启动sqlserver服务单用户模式net start "SQL Server (GJDB)" /m--连接sqlserversqlcmd -S "node01\gjdb"---恢复备份即可use mastergoRESTORE DATABASE [master] FROM  DISK = N'S:\backup\system\master_full_20151115010000.bak' WITH  FILE = 1,NOUNLOAD,  REPLACE,  STATS = 5GORESTORE DATABASE [msdb] FROM  DISK = N'S:\backup\system\msdb_full_20151115010003.bak' WITH   REPLACEGO

0 0