导航

SQLServer2005 备份语句

Posted on 2008-09-10 10:44  DotNet1010  阅读(513)  评论(0编辑  收藏  举报

use [databaseOA]

declare  @filepath varchar(1000)
set @filepath = 'C:\DataBackup\'+ CONVERT(varchar(10), getdate(),112)+'.bak'
BACKUP DATABASE [databaseOA] TO  DISK = @filepath WITH NOFORMAT, NOINIT,  NAME = N'databaseOA-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO