Post reply

Is Configuring log shipping between Standard and Enterprise edition supported?

  • August 4, 2009 at 11:38 am

    #137107

    Hi,

    We have Log shipping configuration setup between 2 SQL server 2005 Enterprise editions.

    Primary: SQL Server 2005 EE and Secondary: SQL Server 2005 EE

    Now we want to Log ship a new SQL Server 2005 standard Edition instance Databases to Existing Secondary instance which is Enterprise Edition.

    Is Configuring log shipping between Standard and Enterprise edition supported?

  • August 4, 2009 at 11:50 am

    #1034445

    yes

    but of course if you are using some enterprise only features on the primary they won't be supported on the secondary, so thats your limiting factor.

    ---------------------------------------------------------------------

  • August 4, 2009 at 12:20 pm

    #1034470

    yes

    but of course if you are using some enterprise only features on the primary they won't be supported on the secondary, so thats your limiting factor

    could you please take me to the BOL link where it says the above information. Because I need to show my Boss(':hehe:');

  • August 4, 2009 at 1:34 pm

    #1034494

    In this link http://msdn.microsoft.com/en-us/library/ms190016(SQL.90).aspx

    where it says

    'Log shipping requires SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition on all server instances involved in log shipping. '

    I think the important word is 'or'.

    see this:

    http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/9d24fa5d-170c-49f2-b8cc-1f7e6d51da8c

    ---------------------------------------------------------------------

  • August 4, 2009 at 5:13 pm

    #1034564

    thanks,

    From BOL, http://msdn.microsoft.com/en-us/library/ms190016%28SQL.90%29.aspx

    Log shipping requires SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition on all server instances involved in log shipping. '

    According to the above statement, do we need to have the same edition of SQL Server on both Primary and Secondary involved in log shipping? or

    Any of the above 3 combination Standard, work group & Enterprise edition. I mean:

    Primary: Secondary:

    Enterprise Standard

    Standard Enterprise

    Enterprise Work group

    Work group Enterprise

    Standard Work group

    Work group Standard

    any body implemented the above combination of different editions in configuring log shipping in SQL Server 2005??

    please confirm me...

    thanks

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

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