DECLARE @strPath NVARCHAR(200)
set @strPath = replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'E:\Backup\Mis.Backup\Mis_' + @strPath + '.bak'
BACKUP DATABASE Mis TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
posted on 2008-12-20 22:57
Documents 阅读(413)
评论(0) 编辑 收藏 所属分类:
SQL Server