SQL Server Performance

Logshipping question

Discussion in 'SQL Server Log Shipping' started by rajeshraghavan, Nov 15, 2005.

  1. rajeshraghavan New Member

    Hi
    Just have a quick question about log shipping,

    We have Server A shipping logs every 15 minutes to Server B, Now can SERVER C also ship logs to the same server B simulataneously, Is it a valid Setup?? Will log shipping work



    Thanks

    Rajesh

  2. SQLDBcontrol New Member

    Yes,

    That is possible but Server C cannot ship to the same database on Server B (not that I can see how you'd want this).

    1) Server A can ship database Northwind to Server B.

    2) Server C can ship database Northwind to Server B but the database has to be called something other than Northwind - Like NorthwindC or something else.

    Karl Grambow

    www.sqldbcontrol.com
  3. satya Moderator

    Check the jobs scheduled does not overlap to avoid any mixup.
    It works on my side of setup.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. rajeshraghavan New Member

    Thanks a lot for the replies.

Share This Page