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

Jan 24 '12 #1

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.

Jan 24 '12 #2

nav mac

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

Jan 25 '12 #3

NeoPa

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

Jan 25 '12 #4