Options
Logshipping - Orphan users on a Read Only db
sai_sathish
Posts: 2
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
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
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.