Main | Reduce Transaction Log File Size »
Friday
Oct212011

Reducing Log File size when CDC or replication is enabled

So recently I went to make a copy of a database that had CDC enabled for certain tables.  It was a non-production copy, so I didn't need CDC in play.  However because the original database had CDC I found that the Transaction Logs couldn't be truncated because there was stuff that hadn't been captured yet.

Luckily I found this Microsoft article:  http://msdn.microsoft.com/en-us/library/ms173775.aspx

After executing the following command I was able to truncate the log:

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,     @time = 0, @reset = 1

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>