Truncar / Diminuir tamanho do LOG do SQL Server 2012

Truncar ou diminuir o arquivo de LOG do SQL Server

[code type=sql]
USE master
GO
SELECT database_id [ID], name [Banco], compatibility_level [Versao],
recovery_model_desc [Model] FROM sys.databases
GO
ALTER DATABASE SET RECOVERY SIMPLE
GO
use
GO
sp_helpfile
GO
DBCC SHRINKFILE (, 1)
GO

Share and Enjoy !

0Shares
0 0 0