none
Configure logshipping

    Question

  • Hi Team,

    I have configured logshipping, but I want to add one more server on logshipping. is it possible or not if it is possible how can we do add please let me know.


    subu

    Sunday, April 13, 2014 5:37 AM

Answers

All replies

  • Yes , it is possible 

    http://technet.microsoft.com/en-us/library/ms187103.aspx

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d473a786-d4dc-4246-b5bf-3dc9624f3ca2/log-shipping-with-2-secondary-servers?forum=sqldisasterrecovery


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, April 13, 2014 5:46 AM
  • Hi Team,

    I have configured logshipping, but I want to add one more server on logshipping. is it possible or not if it is possible how can we do add please let me know.


    subu


    What do you mean exactly by one more Server ? Can you please explain your requirement ?.If you want to say that on server which is already as secondary server for one database can I make it also a secondary server for other database ,then yes it is possible.But this is my guess what is your requirement  ?

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Sunday, April 13, 2014 9:32 AM