June 24, 2011 at 4:50 pm
My subscriber database file, taking part in transactional replication, is growing to many times the size of the publication database it is subscribing to. I am on 2008 R2 and this never happened on SQL 2005, and yes I am using exactly the same scripts.
Can anyone give me some advice?
Edit: Just for clarification, this is the mdf file not the ldf.
June 24, 2011 at 5:01 pm
That is strange. I might set up a trace that logs activity to see what is happening here.
June 25, 2011 at 1:23 pm
Do you do any index maintenance on the subscriber side? If not, page and extent splits may be the cause.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply