Do sql server Roles are copied into secondary server when a manual failover is done in Log shipping?

  • Do sql server Roles are copied into secondary server when a manual failover is done in Log shipping?

  • roles and users are stored inside the database, just like any other table or view object, so yes, roles/users will exist on your standby server.

    the LOGINS are stored in the master database, and they may or may not be there...you need to make sure they are copied, as they are the items that get mapped to the users that exist on your database.

    the best way to do that is to script them out with their encrypted login with the microsoft procedure sp_revlogin, which has a version for each version for SQL, i believe (2000/2005/2008)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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