logshipping setup with two standby db servers.

[Kamal]

Hi,
Currently we have logshipping setup with one production db server
sending the logs to one standby database server.

we would like to have setup where there will be two standby db
servers. Second server will be located in different country.
Kindly let me know if we can have the setup where
there is one primary server and two standby db servers.

When I tried to configure the same I am not able to complete the
maintenance plan.
It gives error that logshipping monitor already exists.
Please help me. tks in advance.
Regards
Kamal

[Simon Hayes]

ka****@melstar.com (Kamal) wrote in message news:<a4*************************@posting.google.c om>...

Hi,
Currently we have logshipping setup with one production db server
sending the logs to one standby database server.

we would like to have setup where there will be two standby db
servers. Second server will be located in different country.
Kindly let me know if we can have the setup where
there is one primary server and two standby db servers.

When I tried to configure the same I am not able to complete the
maintenance plan.
It gives error that logshipping monitor already exists.
Please help me. tks in advance.
Regards
Kamal

Yes, this is possible:

http://support.microsoft.com/default...nal.asp#modify
http://www.microsoft.com/resources/d...rt4/c1361.mspx

You might also want to check this article, which describes one
situation where you might get that error:

http://support.microsoft.com/default...298743&sd=tech

Also check out "Modifying Log Shipping" in Books Online.

Simon