Set NoCount ON
 
Declare @tableName varchar(200)
 
set @tableName=''
 
While exists
 
(

 
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>' )