Logshipping - Orphan users on a Read Only db

sai_sathishsai_sathish Posts: 2
edited April 8, 2009 5:14AM in SQL Backup Previous Versions
Hello,

Does anyone know how I can attach the Orphan users on a read only db?

Here is what I did. I created a log shipping using Redgate Backup 5 and the destination database is a read-only. However the log shipping did not take care of users and they are not attached to the database. How can I overcome or any solution to this.

Thanks,
Sathish

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Sathish,

    As far as I know, the only to hook orphaned users back up to a log-shipped database is to use the change_users_login stored procedure. Unfortunately this will need to modify the database to reset the userids, so you can't run this on a read-only database.

    In a DR scenario, you would typically build in some logic to fix all of the logins as part of the script for bringing the database back up from standby.
Sign In or Register to comment.