Reduce Size of Database

If you the getting the error like your transaction log is full when updating then put this query
USE DatabaseName
GO
DBCC SHRINKdatabase(DatabaseName, 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY
DBCC SHRINKdatabase(DatabaseName, 1)

--dbcc opentran
--kill 56
--SELECT * FROM sys.dm_os_waiting_tasks;
--SELECT * FROM sys.dm_tran_locks