SqlServer批量压缩数据库日志-多数据库批量作业,批量备份还原_sqlserver还原数据并压缩

--作业定时压缩脚本 多库批量操作
DECLARE @DatabaseName NVARCHAR(50)
DECLARE @ExecuteSql NVARCHAR(MAX)
SET @ExecuteSql=''
DECLARE name_cursor CURSOR
FOR
	SELECT name FROM  master..sysdatabases WHERE name NOT IN ( 'master', 'model', 'msdb', 'tempdb', 
	'northwind','pubs' ) 
OPEN name_cursor;  
FETCH NEXT FROM name_cursor INTO @DatabaseName;  
WHILE @@FETCH_STATUS = 0
    BEGIN   
	    SET @ExecuteSql =''
		SET @ExecuteSql +='
		    USE ['+@DatabaseName+'];
			DECLARE @Error INT
			SET @Error=(SELECT TOP 1 size/128.0 - CAST(FILEPROPERTY([NAME], ''SpaceUsed'') AS int)/128.0 AS AvailableSpaceInMB FROM sys.database_files ORDER BY [NAME] DESC)
			--PRINT @Error
			IF(@Error>1)
				BEGIN
					ALTER DATABASE ['+@DatabaseName+']　　--数据库名字
					SET RECOVERY SIMPLE;　　--设置简单恢复模式
					DB