--先还原最近的一次完整备份:
RESTORE DATABASE [CODS]
FROM DISK = N'H:\cods\wz\CODS_backup_2020_09_06_000005_3599146.bak'
WITH FILE = 1,
NOUNLOAD,
STATS = 10,
NORECOVERY,REPLACE
GO
--再还原差异备份:
RESTORE DATABASE [CODS]
FROM DISK = N'H:\cods\cy\CODS_backup_2020_09_08_060004_8441911.bak'
WITH FILE = 1,
NOUNLOAD,
STATS = 10
GO
sqlserver 备份还原
最新推荐文章于 2024-08-24 10:11:25 发布