如何使用SQL命令自动备份SQL数据库，然后删除超过5天的任何数据库

DECLARE @DBName NVARCHAR(128) = 'YourDatabaseName';
DECLARE @BackupPath NVARCHAR(260) = 'C:\Backup\';

DECLARE @FileName NVARCHAR(260) = @BackupPath + @DBName + '_' + CONVERT(NVARCHAR(20), GETDATE(), 112) + '_Full.bak';

BACKUP DATABASE @DBName
TO DISK = @FileName
WITH INIT, NAME = 'Full Backup of YourDatabaseName';

DECLARE @BackupPath NVARCHAR(260) = 'C:\Backup\';
DECLARE @Days INT = 5;

DECLARE @OldestDate DATETIME = DATEADD(day, -@Days, GETDATE());

DECLARE @FileList TABLE
(
    FileName NVARCHAR(260)
);

INSERT INTO @FileList (FileName)
SELECT TOP 1000 
    BackupFile = RTRIM(Filename)
FROM 
    msdb.dbo.backupset bs
JOIN 
    msdb.dbo.backupmediafamily bmf ON bmf.media_set_id = bs.media_set_id
WHERE 
    bs.type = 'D' AND
    DATEDIFF(day, bs.backup_finish_date, GETDATE()) > @Days;

DECLARE @cmd NVARCHAR(4000);

WHILE EXISTS (SELECT 1 FROM @FileList)
BEGIN
    SELECT TOP 1 @cmd = 'DEL ' + FileName FROM @FileList;
    EXEC xp_cmdshell @cmd, NO_OUTPUT;
    DELETE FROM @FileList WHERE FileName = @cmd;
END;

0 0 * * * /path/to/sqlcmd -S your_server -d your_database -i /path/to/backup_database.sql
0 1 * * * /path/to/sqlcmd -S your_server -d your_database -i /path/to/cleanup_old_backups.sql