select @SQLSkript = (@SQLSkript + 'BACKUP DATABASE [' + name + '] TO DISK = N'''+@BackupDest+name+'.bak'' WITH COMPRESSION, COPY_ONLY;' + CHAR(10)) from sys.databases where database_id > 4;
select @SQLSkript
SET @SQLSkript = '';
select @SQLSkript = (@SQLSkript + 'RESTORE DATABASE [' + db.name + '] FROM DISK = N'''+@BackupDest+db.name+'.bak'' WITH FILE = 1 ' + mf.name + ' ,RECOVERY, REPLACE;' + CHAR(10))