数据库备份_作业

declare @name varchar(250) set @name=N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\'+replace(REPLACE(convert(varchar(50),GETDATE(),120),' ','_'),':','_')+'ReportServerTempDB.bak' BACKUP DATABASE [ReportServerTempDB] TO  DISK =  @name WITH NOFORMAT, NOINIT,  NAME = N'ReportServerTempDB-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10