Post reply

Step-by-Step how to configure SQL server 2000 log shipping?

  • August 3, 2010 at 12:05 pm

    #238432

    Step-by-Step how to configure SQL server 2000 log shipping?

    i want configure to sqlserver 2000 logshipping

  • August 4, 2010 at 6:25 am

    #1202025

    ganeshanmsc (8/3/2010)

    Step-by-Step how to configure SQL server 2000 log shipping?

    i want configure to sqlserver 2000 logshipping

    Is anything wrong with Microsoft documentation?

    In my opinion - in a case like this - nothing beats vendors documentation, you may want to start here http://support.microsoft.com/kb/323135

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 4, 2010 at 8:30 am

    #1202115

    ganeshanmsc (8/3/2010)

    Step-by-Step how to configure SQL server 2000 log shipping?

    i want configure to sqlserver 2000 logshipping

    What you've posted here is the equivalent of me defecating on your shoes. If you have a specific question, please feel free to ask, but this sort of thing is best handled by reading documentation as suggested more kindly by the poster above me.

    Thanks 😉

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • August 6, 2010 at 3:02 am

    #1203309

    Could give you a small check list and you go through the KB link given to setup log shipping.

    1) Finalize on the Primary & Stand BY server

    2) Create a log shipping account domain account and add it to the admin group on both primary & Standby Servers

    3) Shared the backup & Copy folders on Primary & Standby Servers

    4) Give FULL control to the log shipping account on these folders

    5) Planned the Trasaction log backup frequency

    6) Plan the the logins trasfer keep the script ready and test

    7) Check what is the best fail over bench mark you have

    8) Test Test & Test your scripts and setting

    Appreciate if you the do posting in the relevant forum.

    "More Green More Oxygen !! Plant a tree today"

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

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