Results 1 to 4 of 4

Thread: log shipping to 2 different servers

  1. #1
    Join Date
    Nov 2002
    Posts
    261

    log shipping to 2 different servers

    I have a solution where I have 3 servers to setup in a log shipping environment. The primary and first failover are located at the same location. The 3rd failover is across a slow LAN link. Haven't done it, but inside the wizard can you designate more than 1 server. Also, I have seen back and forth arguments over where the log shipping monitor should reside. With the budget I can't afford a box to just sit there and run the log shipping. Would i be better off putting the log shipping monitor on the standby server that is located at the facility? We have one client where I have the log shipping running on the primary, and the performance impact is non-exsistent.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can have more than one secondary server (standby server) in a log shipping. During the setup you can add server in the wizard or later (modify the log shipping database maintenance plan).

    You are better of setting up log shipping monitor on the secondary server. The performance impact depends on the frequency of backup/restore.

  3. #3
    Join Date
    Nov 2002
    Posts
    261
    Doing it every five minutes

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    That's not bad. After each successful backup, copy and restore log shipping writes to a table in log shipping monitor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •