数据库备份

declare @filename nvarchar(100) set @filename='M:\\DBBACKUP\DS_db_'+replace(replace(replace(replace(CONVERT(char(16), getdate(),

120 ),'-',''),'',''),':',''),' ','') +'.bak' -- print @filename BACKUP DATABASE [Enterprise] TO DISK = @filename WITH NOINIT , NOUNLOAD ,

NAME = N'Enterprise_BACKUP', NOSKIP , STATS = 10, NOFORMAT

posted @ 2009-04-23 11:08  流泉飞石  阅读(136)  评论(0)    收藏  举报