Post reply

distribution DB reorg

  • November 11, 2011 at 9:06 am

    #390838

    I was going to setup a reorg job for the Distribution Database on a server that is distribution agent. I was wondering if the standard 'reorganize pages with default amount of free space', 'sort results in tempdb' and 'keep index online' still apply? or should a system db be done differently?

  • November 11, 2011 at 10:00 am

    #1406457

    Its a standard database so all the same rules apply. You may want to consider stopping the logreader and distribution agent whilst doing this to speed things up but its up to you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply