Shrinking SQL Server log files

--SQL Server 2008

Use [master]

GO

ALTER DATABASE [UENCDOP1] SET RECOVERY simple with no_wait

GO

ALTER DATABASE [UENCDOP1] SET RECOVERY Simple

--Simple Mode

GO

Use [UENCDOP1]

GO

DBCC shrinkfile (N ' Pencdop1_log ', one, truncateonly)

GO

--Here's dnname_log if you don't know what the name is in sys.database_files, you can query it with the following annotated statement

Use [UENCDOP1]

GO

SELECT file_id,

Name

From Sys.database_files;

GO

Use [master]

GO

ALTER DATABASE [UENCDOP1] SET RECOVERY full with no_wait

GO

ALTER DATABASE [UENCDOP1] SET RECOVERY full

--Revert to full mode

GO

--SQL Server 2005

BACKUP LOG [Hc1queue] with no_log

Go

DUMP TRANSACTION [Hc1queue] with no_log

Go

Use [Hc1queue]

DBCC Shrinkfile (2)

Go

Shrinking SQL Server log files