SqlServer 配合代理实现自动备份的脚本

DECLARE @backupDatabase NVARCHAR(100) = 'your-db-name';
DECLARE @backupBasePath NVARCHAR(MAX) = 'path-to-backup';
DECLARE @backupFileName NVARCHAR(255);
DECLARE @backupTime DATETIME = GETDATE();
DECLARE @backupFilePath NVARCHAR(MAX);

SET @backupFileName = @backupDatabase + '_backup_' + REPLACE(CONVERT(NVARCHAR(20), @backupTime, 112), '-', '') + '_' + 
REPLACE(CONVERT(NVARCHAR(20), @backupTime, 108), ':', '') + '.bak';

SET @backupFilePath = @backupBasePath + @backupFileName;

BACKUP DATABASE @backupDatabase
TO DISK = @backupFilePath
WITH FORMAT,COMPRESSION,STATS = 10;

PRINT 'Database backup completed successfully. Backup file: ' + @backupFilePath;