--启动sqlserver服务单用户模式
net start "SQL Server (GJDB)" /m
--连接sqlserver
sqlcmd -S "node01\gjdb"
---恢复备份即可
use master
go
RESTORE DATABASE [master] FROM DISK = N'S:\backup\system\master_full_20151115010000.bak' WITH FILE = 1,NOUNLOAD, REPLACE, STATS = 5
GO
RESTORE DATABASE [msdb] FROM DISK = N'S:\backup\system\msdb_full_20151115010003.bak' WITH REPLACE
GO
sqlserver还原master和msdb
最新推荐文章于 2024-07-22 09:08:40 发布