数据库备份作业

DECLARE @DT AS VARCHAR(255); (255),SET @DT = N'E:\DataBaseBackup\dataBackupName_' + CONVERT(VARCHARGETDATE(),12) + '_auto.BAK'; BACKUP DATABASE [DataBaseName] TO DISK = @DT WITH NOFORMAT, NOINIT, NAME = N'ERP-完整 数据库 备份', SKIP, NOREWIND,

NOUNLOAD,  STATS = 10 GO

原文地址:https://www.cnblogs.com/xiaoyu369/p/2323270.html