June 20, 2008 at 1:04 pm
Hi,
On one of our servers we are restoring differential backup from production to reporting server on daily basis and we mark database as read-only after differential backup restoration. Now, some users are complaining because they are not able to access the restored database due to orphan logins problem.
Now I don't know whether its possible for me to put the restored database in single user mode and run sp_change_users_login for orphan logins and put the database back into read-only mode? Will the next differential backup file restoration get failed as I changed the database state and ran sp_change_users_login?
Please help.
Manu
June 20, 2008 at 1:56 pm
copy the logins over using sp_help_revlogin, that will maintain the sids and you won't get orphaned users. As this is SQL2000 ensure you get the correct default database and language set up as well.
---------------------------------------------------------------------
June 20, 2008 at 2:07 pm
Thanks for the reply George but my concern is that would I be able to restore the differential backup once I execute the sp_change_users_login stored procedure after putting up the database in single user mode?
Manu
June 20, 2008 at 2:11 pm
once you online the database to modify it you will not be able to restore further differential backups. Hence my feeling you need to change your strategy for recovering users
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply