SQL Server Performance

Log Shipping from Spanish Forum

Discussion in 'SQL Server Log Shipping' started by Luis Martin, Jun 5, 2004.

  1. Luis Martin Moderator

    I have 2 databases and I would like to have a 3rd database with replication of first 2.
    Something like log shipping with one database to another, but now I need 2 database to 1 new.

    Is it posible?



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  2. satya Moderator

    Using sp_add_log_shipping_plan_database SP you can add another database to the current log shipping plan, but the 3rd database is participating in replication I'm unsure how it reverts.
    As I never tried inputting replicated database to the log shipping.

    For instance on the debate of replication vs log shipping :
    There are other considerations. For instance, log shipping gets changes to permissions but replication does not. Replication can also be more time consuming if you switch roles a lot. And replication prevents many schema changes from being made.
    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Luis Martin Moderator

    Thanks Satya, original was in spanish and English too. You response both. I'll close Spanish post.
    I suggest to you to close this one.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  4. InetSQL New Member

    Hi guys... thanks for your quick answer....
    I tried the SP just like this:

    EXECUTE msdb.dbo.sp_add_log_shipping_plan_database
    @plan_name = N'FIRST.TEST_logshipping',
    @source_database = N'NEW',
    @destination_database = N'TEST',
    @load_delay = 60

    but I recieved this error...

    Server: Msg 14424, Level 16, State 1, Procedure sp_add_log_shipping_plan_database, Line 30
    The database 'TEST' is already involved in log shipping.
    (First= SourceServer *** TEST = SourceDB on First *** NEW = the one that I want to integrate)

    so... I think is not possible... if there's another way to do this please let me know...

  5. satya Moderator

Share This Page