How can we help you today? How can we help you today?

Logshipping - Orphan users on a Read Only db

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
sai_sathish
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.