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

最新推荐文章于 2023-06-03 08:35:04 发布

snowman_sp

最新推荐文章于 2023-06-03 08:35:04 发布

阅读量955

点赞数

分类专栏： Database System技术积累文章标签： sql database disk

本文链接：https://blog.youkuaiyun.com/snowman_sp/article/details/363034

版权

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

124 篇文章

订阅专栏

Database

7 篇文章

订阅专栏

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

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