Post reply

Fix orphaned users after restoring database to another server

  • May 1, 2014 at 6:34 pm

    #292936

    Comments posted to this topic are about the item Fix orphaned users after restoring database to another server

  • July 18, 2014 at 10:23 am

    #1730689

    Hello there,

    Will this query help to map the logins to respective database users on the server at which restore is performed.

  • July 18, 2014 at 7:49 pm

    #1730812

    akhamoshioke (5/1/2014)

    Comments posted to this topic are about the item <A HREF="/scripts/Orphan+users/109993/">Fix orphaned users after restoring database to another server</A>

    A better approach is to get the info from the original server, and copy it to the new server -- i.e create the login with the correct sid. Do that and then do your restore, and the login is not orphaned...

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

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