SQLServer2005 备份语句

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