💾SQL BACKUP alles sichern

'@BackupPath=' ggfls anpassen!

DECLARE @DBName VARCHAR(255)   
DECLARE @DateTime NVARCHAR(20)
DECLARE @BackupPath NVARCHAR(256)
DECLARE @BackupName NVARCHAR(256)
DECLARE @BackupFileName NVARCHAR(256)

-- Pfad, wo die Sicherungsdateien gespeichert werden sollen
SET @BackupPath = 'C:\backupfpad\'  

-- Format für Datum und Uhrzeit (Jahr-Monat-Tag-Stunde-Minute)
SET @DateTime = REPLACE(CONVERT(VARCHAR, GETDATE(), 120), ':', '-') 

DECLARE db_cursor CURSOR FOR  
SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  -- Ignoriere Systemdatenbanken

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @DBName   

WHILE @@FETCH_STATUS = 0   
BEGIN   
       SET @BackupName = @DBName + '+++' + @DateTime + '.bak'
       SET @BackupFileName = @BackupPath + @BackupName

       -- Sicherungsbefehl
       BACKUP DATABASE @DBName TO DISK = @BackupFileName WITH NOFORMAT, NOINIT,  
       NAME = N'Vollständige Datenbanksicherung', SKIP, NOREWIND, NOUNLOAD, STATS = 10

       FETCH NEXT FROM db_cursor INTO @DBName   
END   

CLOSE db_cursor   
DEALLOCATE db_cursor