DECLARE @DBName       VARCHAR(64)
DECLARE @RecoverModel INT
DECLARE @cmd          NVARCHAR(2048)

-- Курсор по БД
DECLARE DB_Curs CURSOR FOR
  SELECT
    d.name,
    d.recovery_model
  FROM
    sys.databases d
  WHERE
    (d.name NOT IN ('master','tempdb','model','msdb')) AND (d.recovery_model = 1)
  ORDER BY
    d.name

OPEN DB_Curs
FETCH NEXT FROM DB_Curs INTO @DBName, @RecoverModel

WHILE @@FETCH_STATUS = 0
BEGIN
  IF @RecoverModel = 1
  BEGIN
-- SHRINK LOG
    SET @cmd = 'USE ' + @DBName + '
                CHECKPOINT
                BACKUP LOG ' + @DBName + ' WITH TRUNCATE_ONLY
                CHECKPOINT
                DBCC SHRINKFILE(2, TRUNCATEONLY)'
    EXECUTE sp_executesql @cmd

-- BACKUP
    EXEC Create_Backups @DBName, 'FULL'
  END
 
-- SHRINK DB
  SET @cmd = 'DBCC SHRINKDATABASE (' + @DBName + ')'
  EXECUTE sp_executesql @cmd

  FETCH NEXT FROM DB_Curs INTO @DBName, @RecoverModel
END

-- Закрытие курсора
CLOSE DB_Curs
DEALLOCATE DB_Curs

SELECT @@version

SELECT @@version