Post reply

Editions of Primary and Secondary in Log shipping

  • April 30, 2009 at 1:32 pm

    #137216

    Hi,

    We have SQL Server 2005 Enterprise edition x64 and we want to configure log shipping for disaster recovery.

    Can we have SQL Server 2005 Standard edition in Secondary Server? or It must be Enterprise edition?

    Please advice me

  • April 30, 2009 at 1:53 pm

    #986925

    From BOL:

    Log shipping has the following requirements:

    SQL Server 2005 Standard, SQL Server 2005 Workgroup, SQL Server 2005 Enterprise Edition, or a later version, must be installed on all server instances involved in log shipping.

    The servers involved in log shipping should have the same case-sensitivity settings.

    The databases in a log shipping configuration must use the full recovery model or bulk-logged recovery model.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

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