转自:http://www.fovweb.com/web/sqlserver-backup.html
DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'D:\DB_BAK\' + 'JXC'+@strPath + '.bak'
BACKUP DATABASE [JXC] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
记得在SQL SERVER 服务管理器中 启动 SQL Server Agent ,auto打钩