To Shrink or Compress the DB file or DB log

MS SQL Server 2005

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

Note:- Provide the Database name and the TransactionLogName within single quotes


MS SQL Server 2008

USE [DatabaseName]
GO
ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(<TransactionLogName>, 1)
ALTER DATABASE [DatabaseName] SET RECOVERY FULL WITH NO_WAIT
GO

Note:- Provide the Database name and the TransactionLogName within single quotes