August 18, 2010 at 3:58 am
can we use different sqlserver editions in a single logshipping configuration?
Like , can we use enterprise for primary server , standard for secondary server and another edition for monitor server?.
August 18, 2010 at 4:13 am
I'm pretty sure that this is possible as there's no restriction on restoring databases across different editions (save for situations were enterprise features would prevent this - for example, partition functions come to mind).
This is what you get from the msdn website:
Requirements
--------------------------------------------------------------------------------
Log shipping has the following requirements:
•SQL Server 2005 Standard Edition, SQL Server 2005 Workgroup Edition, or SQL Server 2005 Enterprise Edition 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.
Best way to know for sure is to test this out.
August 18, 2010 at 4:16 am
Yes.
In SQL Server 2005 the process of implementing Log Shipping is embedded with the Workgroup, Standard and Enterprise editions of SQL Server.
Cheers,
- Win.
" Have a great day "
August 18, 2010 at 4:17 am
thanks for the info.........
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply