maniacoo
04-13-2023, 03:51 PM
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
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