本文共 897 字，大约阅读时间需要 2 分钟。
-- 完整备份declare @db_name varchar(100)set @db_name = 'WSS_Content_Test';declare @db_location varchar(100)set @db_location = 'D:\spbr0002\0000000B.bak'; -- 确保文件夹存在backup database WSS_Content_Testto disk = @db_locationwith name = @db_name, stats=5, noinit, noskip, noformat, norewind; -- 差异备份to disk = @db_locationwith name = @db_name, stats=5, noinit, noskip, noformat, norewind, differential;
-- 还原declare @db_name varchar(100)set @db_name = 'WSS_Content_Test';declare @db_location varchar(100)set @db_location = 'D:\spbr0002\0000000B.bak'; -- 确保数据库存在if exists(select * from master..sysdatabaseswhere has_dbAccess(name)=1 and name=@db_name)beginalter database WSS_Content_Testset single_user with rollback immediateendrestore database WSS_Content_Testfrom disk = @db_locationwith stats=5, file=1, replace, norewind, nounload, recovery;
转载自: [技术博客](https://www.cnblogs.com/huangjianwu/p/4536491.html)