Tagged: shrink

0

Shring SQL log file

USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([TestDb_Log], 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO   Where TestDB, is the database name, and TestDB_Log is the SQL Log file name.