|
Home > Archive > MS SQL Server > August 2005 > URGENT ! :- How to add user in database in seconday server in log shipping
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
URGENT ! :- How to add user in database in seconday server in log shipping
|
|
| amish 2005-08-31, 11:23 am |
| I have configured log shipping.
I want to add a user for reporting purpose in the secondary server ,but
the database on secondary server is in read only - warm stand by mode.
How can I add a user in the database which is configured for log
shippng.
Is there any way so that I can stop log shipping , bring out the
databse from read only mode, add a user and then again start log
shipping?
Thanks
| |
|
| maybe you must add the user on the first server first then the user login
will be copied to the second server when the log restored?
"amish" <shahamishm@gmail.com> wrote in message
news:1125502085.455773.211210@g14g2000cwa.googlegroups.com...
>I have configured log shipping.
> I want to add a user for reporting purpose in the secondary server ,but
> the database on secondary server is in read only - warm stand by mode.
> How can I add a user in the database which is configured for log
> shippng.
> Is there any way so that I can stop log shipping , bring out the
> databse from read only mode, add a user and then again start log
> shipping?
>
> Thanks
>
|
|
|
|
|