declare @name varchar(250) set @name='C:\SqlBackUp\org\'+ convert(varchar(50),getdate(),112)+'.bak' BACKUP DATABASE[数据库名] TO DISK = @name WITH NOFORMAT, NOINIT, NAME = N'数据库名-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD
