The transaction log for database XXXX is full

First get the name of your database logs

use ycsoftware
select * from sys.database_files

Next just run the following to truncate the logs

use ycsoftware
go
dbcc shrinkfile (ycsoftware_Log,1)
backup log ycsoftware with truncate_only
dbcc shrinkfile (ycsoftware_Log,1)
go
Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn