SQL Server 2008 Database compressed log file size script (compressed local file, compressed from hundred g to MB)

Do project database file more than 200G, search the method of compressing data log everywhere, but a lot of log file's physical size has not changed, execute the following script can change the physical file size, the formal production environment is used with caution, can first local test decide whether to use (db_name for the corresponding database name);

Use [master]

GO

ALTER DATABASE db_name SET RECOVERY simple with no_wait

GO

ALTER DATABASE db_name SET RECOVERY Simple--Easy mode

GO

Use Db_name

GO

DBCC shrinkfile (N ' Db_name_log ', one, truncateonly)

GO

Use Db_name

GO

SELECT file_id, name from Sys.database_files;

GO

Use [master]

GO

ALTER DATABASE db_name SET RECOVERY full with no_wait

GO

ALTER DATABASE db_name SET RECOVERY Full--Revert to complete mode

GO

SQL Server 2008 Database compressed log file size script (compressed local file, compressed from hundred g to MB)