Logshipping - Orphan users on a Read Only db

sai_sathish

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

Brian Donahue

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.