sql2005数据库备份

技术2022-05-19 24

数据库备份

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

专利

最新回复(0)