Stefano.Aguiar
31/05/2015, 10:26 AM
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
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