How to remove second log file in SQL Server

ALTER DATABASE dbname SET RECOVERY SIMPLE
GO
BACKUP LOG [dbname] WITH TRUNCATE_ONLY
GO
USE dbname
GO
DBCC SHRINKFILE (dbname_Log,0)
GO
ALTER DATABASE dbname SET RECOVERY FULL
GO
USE [dbname]
GO
DBCC SHRINKFILE (dbname_Log,0)

Update me when site is updated

Leave a Reply

You must be logged in to post a comment.