Log Shipping from Spanish Forum | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log Shipping from Spanish Forum

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.
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.
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.
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…
KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;314515&sd=tech for Log shipping FAQs, for informaton. Try to remove the specified database from log shipping and re-enable it with the referred stored procedure. 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.
]]>