June 9, 2009 at 12:21 pm
Hi,
We are planning to implement Log shipping in SQL server 2005. Can we configure log shipping between 2 servers Server A (Primary) and Server B (Secondary) where Server A is in ABC.com domain and Server B is in XYZ.com?
If yes, what are the things to consider in compared to Servers in Same domain Vs Servers in different domain?
June 9, 2009 at 12:40 pm
You definitely can do that. Really, the only difference is making sure that you set up logins for the shipping that allow you to connect and do what you need to do. It's very straightforward.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 9, 2009 at 12:51 pm
See this KB article for details on required security settings:
June 9, 2009 at 1:33 pm
Can we use the LogShipping wizard to configure LogShipping, if the Primary and Secondary are in different Domains?
June 9, 2009 at 3:01 pm
You need to have a file share on the primary server (or somewhere on an intermediary server) which should be accessible from the secondary server. This will likely require some firewall adjustsments as well as either inter-domain trust or mirrored accounts.
June 11, 2009 at 10:14 am
bbychkov (6/9/2009)
You need to have a file share on the primary server (or somewhere on an intermediary server) which should be accessible from the secondary server. This will likely require some firewall adjustsments as well as either inter-domain trust or mirrored accounts.
FTP is probably a good option for that. Haven't tried it, but it should be easy enough to test.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply