SQL Server Performance Forum – Threads Archive

Log shipping on shared environment

I am currently running a site on a shared environment with sql db. The account is with verio.com: Windows Server 2003m SQL 2000. What we would like to do is create a back up site with a backup db. I would like this functionality so that in the event of a crash, while the current site is being repaired, or if the server is down for a prolonged period, I can simply switch to the backup site w/ db. I t sounds like log shipping could work, however can I pull that off in a shared environment, even if I have to get a second account?

I don’t see any issue in deploying Log shipping in shared environment.
Can you explain bit more about your doubt in second account. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have 2 domains, one in US and one in UK. They are both seperate trees. I need to configure Log Shipping from UK to US. I have done LS within domains. What needs to be done to accomplish this ?
How will I be able to see the secondary server from the primary ? What kind of accounts needs to be setup ? Is there some some documentation that you can point to ?
Thanks
bj

Can both domains see each other on the network?
Ensure the two-way trust is enabled.
As usual domain account with required privileges has to be used to perform the log shipping and also consider the size of Transaction log backup in order to reduce any contention in file transfer. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>