SQLｓｅｒｖｅｒ　２ｋ　ｂａｃｋｕｐ

最新推荐文章于 2025-08-03 16:12:26 发布

原创最新推荐文章于 2025-08-03 16:12:26 发布 · 993 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #database #disk

System技术积累同时被 2 个专栏收录

124 篇文章

订阅专栏

Database

7 篇文章

订阅专栏

博客介绍了SQL数据库的三种备份方式。包括差异备份（diff backup）、完整备份（full backup）和日志备份（log backup），并给出了每种备份方式的具体SQL代码，通过代码设置备份文件名并将数据库备份到指定磁盘。

部署运行你感兴趣的模型镜像

ＷＡＹ＿１（ｄｉｆｆ　ｂａｃｋｕｐ）

declare @currww nvarchar(15),
@filename nvarchar(50)
set @currww=datename(weekday,getdate())
set @filename='d:/mssql/backup/portal1_prof_diff'+@currww+'.dat'
backup database portal1_prof
to disk=@filename
with differential

set @filename='d:/mssql/backup/portal1_serv_diff'+@currww+'.dat'
backup database portal1_serv
to disk=@filename
with differential

set @filename='d:/mssql/backup/portal1_site_diff'+@currww+'.dat'
backup database portal1_site
to disk=@filename
with differential

set @filename='d:/mssql/backup/sps01_config_db_diff'+@currww+'.dat'
backup database sps01_config_db
to disk=@filename
with differential

ＷＡＹ＿２（ｆｕｌｌ　ｂａｃｋｕｐ）

declare @currww nvarchar(15),
@filename nvarchar(50)
set @currww=datename(weekday,getdate())
set @filename='d:/mssql/backup/master_full'+@currww+'.dat'
backup database master
to disk=@filename

set @filename='d:/mssql/backup/portal1_prof_full'+@currww+'.dat'
backup database portal1_prof
to disk=@filename

set @filename='d:/mssql/backup/portal1_serv_full'+@currww+'.dat'
backup database portal1_serv
to disk=@filename

set @filename='d:/mssql/backup/portal1_site_full'+@currww+'.dat'
backup database portal1_site
to disk=@filename

set @filename='d:/mssql/backup/sps01_config_db_full'+@currww+'.dat'
backup database sps01_config_db
to disk=@filename

ＷＡＹ＿３（ｌｏｇ　ｂａｃｋｕｐ）

declare @currww nvarchar(15),
@filename nvarchar(50)
set @currww=datename(weekday,getdate())
set @filename='d:/mssql/backup/portal1_prof_log'+@currww+'.dat'
backup log portal1_prof
to disk=@filename

set @filename='d:/mssql/backup/portal1_serv_log'+@currww+'.dat'
backup log portal1_serv
to disk=@filename

set @filename='d:/mssql/backup/portal1_site_log'+@currww+'.dat'
backup log portal1_site
to disk=@filename

set @filename='d:/mssql/backup/sps01_config_db_log'+@currww+'.dat'
backup log sps01_config_db
to disk=@filename

您可能感兴趣的与本文相关的镜像