Replication administration

  • Whilest I wait for Microsoft to come to my aide(hhmm). I have question for all you admins out there.

    What typical daily/weekly administration functions do you perform on your Distributor servers.

    System db backups

    User db backups,

    optimization,

    integrity,

    disk monitoring,

    memory/cpu - utilization alerts,

    Job scheduler alerts,

    schema changes,

    permission checks,

    date and time checks

    Talk to me, this is the first job that I have ever used replication at and we use it extensively.

    John Zacharkan


    John Zacharkan

  • This was removed by the editor as SPAM

  • I run the distributor on the publisher and pay very little attention to it over what I normally monitor. Replication is very stable, only problem I see with any frequency is some type of primarykey violation that is data driven, not replication. As long as the jobs are running, you're good, unless you really have to have a super low latency.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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