shrink

Shring SQL log file

admin May 5, 2015 0Comment

USE GO ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(, 1) ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT GO Where TestDB, is the database name, and TestDB_Log is the…