Truncate LOG file
USE master
GO
ALTER DATABASE insurance SET RECOVERY SIMPLE WITH NO_WAIT
go
use insurance
go
DBCC SHRINKFILE(insurance_log, 1)
go
use master
go
ALTER DATABASE insurance SET RECOVERY FULL WITH NO_WAIT
GO
USE master
GO
ALTER DATABASE insurance SET RECOVERY SIMPLE WITH NO_WAIT
go
use insurance
go
DBCC SHRINKFILE(insurance_log, 1)
go
use master
go
ALTER DATABASE insurance SET RECOVERY FULL WITH NO_WAIT
GO