备份数据库sql语句

DECLARE @strPath NVARCHAR(200) 
set @strPath = convert(NVARCHAR(19),getdate(),102 ) 
set @strPath = 'D:\DataBase_' + @strPath + '.bak' 
BACKUP DATABASE [DataBase] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 

 

posted @ 2013-04-24 16:09  小烈哥  阅读(241)  评论(0编辑  收藏  举报