pbb001
Ten Centuries
Points: 1068
More actions
September 24, 2003 at 3:45 am
#82597
Does anyone know if it's ok to run DBCC SHRINKFILE against the transaction log while transactional replication is running?
Thanks.
Paul
Andy Warren
SSC Guru
Points: 119902
September 25, 2003 at 4:53 am
#475763
Totally ok. The default setting is that transactions can't be removed from the log until the logreader has processed them. As long as the logreader is running continuously this happens within a few seconds unless you have a huge transaction.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
September 25, 2003 at 7:10 am
#475795
Thanks Andy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply