Limpando LOG Sql 2014 ou superior

[maniacoo]

Para SQL 2014 ou superior.

USE master
GO

SELECT database_id [ID], name [Banco], compatibility_level [Versao],
recovery_model_desc [Model] FROM sys.databases
GO

ALTER DATABASE MuOnline SET RECOVERY SIMPLE
GO

use MuOnline
GO

sp_helpfile
GO

DBCC SHRINKFILE (MUONLINE_Log, 100)
GO

Creditos : Stefano Aguiar