SQL DB shrink

Mar 11

adminSQL server , No Comments

To shrink the DB Transaction Log file,
USE DatabaseName
GO
DBCC SHRINKFILE(<log file name>, 1)

To find out the Log file details:
USE DATABASENAME
exec sp_helpfile