Post reply

Configuring Log shipping

  • June 9, 2009 at 12:21 pm

    #131040

    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

    #1006997

    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

    #1007004

    See this KB article for details on required security settings:

    http://support.microsoft.com/kb/321247

  • June 9, 2009 at 1:33 pm

    #1007023

    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

    #1007075

    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

    #1008125

    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