--SQL2005
Backup Log dbName with no_log
go
dump transaction dbName with no_log
go
USE dbName
DBCC SHRINKFILE (2)
Go
--SQL2008
USE [master]
GO
ALTER DATABASE dbName SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE dbName SET RECOVERY SIMPLE
GO
USE dbName
GO
DBCC SHRINKFILE (N'dbName_log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE dbName SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbName SET RECOVERY FULL
GO
Backup Log dbName with no_log
go
dump transaction dbName with no_log
go
USE dbName
DBCC SHRINKFILE (2)
Go
--SQL2008
USE [master]
GO
ALTER DATABASE dbName SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE dbName SET RECOVERY SIMPLE
GO
USE dbName
GO
DBCC SHRINKFILE (N'dbName_log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE dbName SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbName SET RECOVERY FULL
GO