backup log <Database_Name, sysname, Database_Name> with truncate_only
go
use <Database_Name, sysname, Database_Name>
go
dbcc shrinkfile (<Database_Name, sysname, Database_Name>_log,  2)
go
 
DBCC SHRINKDATABASE(N'<Database_Name, sysname, Database_Name>' )

-- Disable All constraint (FK)
EXECUTE sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO
 
-- Enable
EXECUTE sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL"
GO