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

    rajeshraghavan, Nov 15, 2005
    #2

  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
    SQLDBcontrol, Nov 16, 2005
    #2

  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.
    satya, Nov 16, 2005
    #2

  4. rajeshraghavan New Member

    Thanks a lot for the replies.
    rajeshraghavan, Nov 17, 2005
    #2

Share This Page