sql2005数据库备份

最新推荐文章于 2013-09-25 10:04:30 发布

double294

最新推荐文章于 2013-09-25 10:04:30 发布

阅读量486

点赞数

分类专栏：我的作品文章标签：数据库 sql database disk

本文链接：https://blog.csdn.net/double294/article/details/6225972

版权

我的作品专栏收录该内容

3 篇文章 0 订阅

订阅专栏

数据库备份

declare @filename nvarchar(100)
set @filename='E://DBBACKUP/YYGameUserDB_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'
',''),':',''),' ','') +'.bak'
-- print @filename

BACKUP DATABASE [YYGameUserDB] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'Enterprise_BACKUP', NOSKIP , STATS = 10, NOFORMAT

set @filename='E://DBBACKUP/WebGameUserDB_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'
',''),':',''),' ','') +'.bak'
-- print @filename
BACKUP DATABASE [WebGameUserDB] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'Enterprise_BACKUP', NOSKIP , STATS = 10, NOFORMAT

set @filename='E://DBBACKUP/YYServerInfoDB_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'
',''),':',''),' ','') +'.bak'
-- print @filename
BACKUP DATABASE [YYServerInfoDB] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'Enterprise_BACKUP', NOSKIP , STATS = 10, NOFORMAT

set @filename='E://DBBACKUP/YYTreasureDB_'+replace(replace(replace(replace(CONVERT(char(16), getdate(), 120 ),'-',''),'
',''),':',''),' ','') +'.bak'
-- print @filename
BACKUP DATABASE [YYTreasureDB] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'Enterprise_BACKUP', NOSKIP , STATS = 10, NOFORMAT