Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
URGENT ! :- How to add user in database in seconday server in log shippingI 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
Post Follow-up to this message
Re: URGENT ! :- How to add user in database in seconday server in log shippingmaybe 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 >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
