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
Site Stats
follow:- RSS
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
follow: RSS