Sql Transaction log for database is full

[nav mac]

Hello all,

when I attempt to run a process against the database, I received transaction log for database is full error(sql 2008 r2),we know its because this database has replication subscriptions with two other systems(DB size-5 Gig with an unbelievable 145 Gig Transaction Log) but not sure how to fix this. We can't even run dbcc shrink as db has replication. There's not enough space on the drives to back it up too, thought durintg the restoration it may truncate the log. But left with no other options. Please help me

[NeoPa]

When you do a database backup there is an option to clear the log.

More details can be found at How to truncate transaction log file via sql statement.

[nav mac]

Thank you NeoPa,but in my case I can't trunacte via log file as its replicated.hmmm .

[NeoPa]

I'm afraid that's beyond my experience then. I never had that problem. Someone else may be able to help.