Sql脚本备份数据库

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