Post reply

Restore DB with Users and Roles

  • January 10, 2008 at 3:49 pm

    #119607

    I have the task of moving a DB to a new server. I performed a full backup of the DB. Is there a script in which when I restore the DB, the users and roles are included?

    Thanks In Advance

  • January 10, 2008 at 4:40 pm

    #766928

    Database roles and users are included in a full backup, so when you restore it, they'll be in the database. You'll need to be sure that the logins that the users are mapped to are also created in the new instance. This article describes how to do that:

    http://support.microsoft.com/kb/246133/en-us

    Greg

    Greg

  • January 10, 2008 at 4:52 pm

    #766930

    Greg,

    Thanks a million!!!!

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

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