Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: Best way to apply SP3 in Replication

    We have a Pub, Dist and Sub Server all running under SP2 with worm update and are looking to apply SP3a . Replication is transactional with heavy usage . What is the best sequence to apply SP3

    can it be spread out in 3 weekends or has to be done all together ?



    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    I don't know why you have to spread the upgrade into three weekends. It shouldn't take that long unless you have many db servers. The SP3 upgrade I did to all db servers, with some minor problems of course, was done in one weekend. We are fully replicated environment. You need to shut down all subscriptions or just stop the SQL Agent on the subscriber(assuming it is a pull), no need to shut down the machine tough. The you shut down the Distributor, if it is on a different machine. Apply SP3 on Publisher first, then Distributor, and Subscriber. Remember to uncheck to autostart SQL Agent so replication agents won't get started incidently. After finished applying SP3, turn the replication back on. If you a certain agents fails, reintialize it. Good Luck.

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Well

    Reason is that databses are really huge and We had occasion when SP3 failed on us leaving dbs in SP2.5 LOL . then we spaend 3 hrs with Msoft and installed the SP3 in Debug mode . I am being careful because we get a window between 1:Am to 5:AM only to do any changes and is too short to do all three if something doesn't go well

    Thanks

  4. #4
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Thanks

    Thanks ..

    Anything specific to do on Publisher other than Backups / Agent Auto-run to manual (and disabling on dist and Subs.)

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    With transactional replication, the proper sequence should be distributor, publisher, and subscriber. The distributor should always be upgraded first. Please refer to SQL 2000 books online <\Installing SQL Server\Upgrading to SQL Server 2000: Overview\ Replication and upgrading> for details.

  6. #6
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Thanks

    I will definately follow the guidelines !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •