User Migration

  • hi

    i am going to apply log shipping on my live database server

    for that purpose i have done stand by server and install sql server 2000

    take a backup from production and restored to stand by server

    Problem:

    I am unable to use database/NT user on stand by server

    i just wana script to migrate DB/NT users from production to stand by server.

    Your help will highly be appriciated.

    Regards

    Syed Naveed

  • If you want to script out users from production database to your stand by database hope this script of mine can help you. Just run this script to your production database then copy the result and execute in your standby database... Please read the comments carefully thanks!!!!!

    "-=Still Learning=-"

    Lester Policarpio

  • thank you so much my dear its really great script

    i havn't words for you

    Best take care of your self

    Regards

    Syed Muhammad Naveed

  • Thanks for the compliment 🙂

    "-=Still Learning=-"

    Lester Policarpio

  • Although I see nothing wrong with the script, there is a perferred method.

    So I suggest that you use the method recommended by MS which is to use the sp_help_revlogin procedure.

    http://support.microsoft.com/kb/246133

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

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