February 4, 2011 at 12:54 am
Hi,
We are running MSSQL2008 (Standard 64 bit - Ver 10.0.2531.0) with 7 replicated off site servers which in 2008 work very reliably.
We have recently started running the 'Rebuild all indexes' as a scheduled maintenance task from the SQL Managnemt Studio and have realised that this task is breaking our replication. Everytime we run the rbuild we get an error 'sp_replcmds' that we have traced to http://msdn.microsoft.com/en-us/library/ms152755.aspx - internal process error.
So far we have not found any resolution to this problem. Has anyone come across this before & found a fix please?
February 4, 2011 at 1:40 am
i guess the log reader agent is timing out... u can try to reduce the batch size in log reader agent profile.
We have the same issue and it works.
February 4, 2011 at 1:57 am
It might also be wise to only rebuild the indexes that are fragmented enough to need rebuilding. There is script in BOL that you can use that will re-build indexes only if the fragmentation level of that index is over given value (30% is the value chosen in BOL). That should reduce the activity on the Log Reader, if it is that timing out that is causing you issues. Index rebuilds will be fully logged so rebuilding them all in one hit could cause you log to 'get busy'
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply