SQLserver 2k backup

原创 2005年04月26日 08:15:00

WAY_1(diff backup)

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

WAY_2(full backup)

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

WAY_3(log backup)

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

CentOS6.5菜鸟之旅:文件权限详解 一、前言                                 Linux下所有资源、设备均被视作文件来操作,而文件权限则是决定用户可各文件

CentOS6.5菜鸟之旅:文件权限详解 一、前言                                   Linux下所有资源、设备均被视作文件来操作,而文件权限则是...
  • cdnight
  • cdnight
  • 2017年05月31日 19:49
  • 344

Centos 利用sqoop从sqlserver导入数据到HDFS或Hive

SQL Server Connect for Hadoop  sqoop是一个开源的工具,能将数据表从关系数据库导入HDFS或Hive上。在安装sqoop之前,需安装好Hadoop和JAVA以及...

Sqlserver2012 评估期已过问题解决

Sqlserver2012评估期已过问题解决 一、背景:   由于之前安装sqlserver2012忘记输入序列号,现在出现评估期已过的问题,前几天忙活半天,才解决,发现网 上叙述都...

SqlServer嵌套事务机制 测试

SqlServer 事务相关:《嵌套事务(一):.NET中嵌套事务运用的一点思考》          《嵌套事务(二):SqlServer中嵌套事务使用》                     ...

k3 12.2wise 注册机

  • 2017年06月01日 10:53
  • 10.7MB
  • 下载

很好的关机酷XP 只有10k

  • 2009年05月01日 07:06
  • 11KB
  • 下载

黑马程序员 (7k面试)银行取票系统学习笔记

---------------------- ASP.Net+Unity开发、.Net培训、期待与您交流! ---------------------   通过对银行取票系统的分析,需要至...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:SQLserver 2k backup
举报原因:
原因补充:

(最多只允许输入30个字)