Post reply

Log Shipping - multiple instances

  • March 27, 2008 at 3:11 pm

    #185668

    Hi,

    We have 4 production SQL2005 Standard Servers. For DR and reporting purposes, we would like to set up log shipping from each of these to one server running 4 instances of SQL server - one for each of the production servers. I understand that we may have performance issues, but is it possible? Any advice would be great. Thank you!!

  • March 27, 2008 at 3:35 pm

    #794904

    I think it is possible as it is based on backup and restore. Instances involved in log shipping should have the same case sensitivity settings.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • March 27, 2008 at 4:59 pm

    #794942

    I agree with Mohan, it should work.



    My blog

  • March 28, 2008 at 7:14 am

    #795147

    Thank you for your responses! Now, to attempt the implementation....

  • March 28, 2008 at 9:25 am

    #795268

    As mentioned above you can go ahead and setup log shipping it should be fine. We have configured for databases of which one is 700 + GB in size. It is working fine till date:). Refer this link for configuring log shipping in Sql Server 2005,

    http://sql-articles.com/index.php?page=articles/lship/lship.htm

    [font="Verdana"]- Deepak[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply