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?