November 1, 2011 at 12:44 pm
This thread was a great help and got me going in the right direction to resolve a problem like this that I was having. Basically the transaction log would not clear because there was a on open transaction being returned by dbcc opentran ('db_name'). I have replication enabled on this database and our Data Center had a major outage so things got a little screwed up. The following link ultimately resolved the problem for me (http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/34ab68ad-706d-43c4-8def-38c09e3bfc3b/) Basically, run the following commands to reset open transactions that have replicated to the subscriber:
exec sp_reldone @xactid = null,
@xact_segno = null,
@numtrans = 0,
@time = 0,
@reset = 1
After running this command you can wait for checkpoint to ocurr or force one with the following command
checkpoint
Once this completes try shrinking your transcation log.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply