Log shipping standby database - how to fix broken users

Last Post 29 Apr 2010 05:13 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
fminns
New Member
New Member

--
28 Apr 2010 06:46 AM
Hi everybody, I wonder if you can help.

I recently set up log shipping (SQL 2005), and so have a readonly/standby database that the logs are being shipped to. The idea was that this database would be used for reporting to take stress off the live box.

However, of course the users on the target box need to be fixed in order for this to work, but I can't do that on a readonly/standby db. What can I do?

As far as I know when setting up log shipping I have no option but to set the target to standby/readonly in the first place so how can I ever fix the users?

Any ideas?

Many thanks

Farren

rm
New Member
New Member

--
29 Apr 2010 05:13 AM
Copy sql logins with sid from source server using ssis copy logins task.
You are not authorized to post a reply.

Acceptable Use Policy