Clear SQL Log

Use the following query

USE [DBName]
GO
ALTER DATABASE [DBName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(DBName_log, 1)
ALTER DATABASE [DBName] SET RECOVERY FULL WITH NO_WAIT
GO

Leave a Reply

Your email address will not be published. Required fields are marked *