July 27, 2006 at 3:19 am
This is a hypothetical question!! Mircosoft have changes the feature set so that log shipping is availble in SQL 2005 Std edition.
If you have SQL 2000 Enterprise Edition, could you log ship from SQL2000 to SQL2005 Std Edition suceesfully if you restricted the databases to compatibility 80 mode???
Naturally you would need to test all the apps with the dbs on the SQL2005 box as well.
I have been to some Microsoft SQL events and they have mentioned that the log shipping technology hasnt really changed in SQL2005 due to the arrival of DB mirroring.
Regards
July 31, 2006 at 9:52 am
I don't know where this is explicitly stated in the documentation, but I am almost positive the answer is that it can't be done.
A SQL 2000 database backup can be loaded in SQL 2005, but the database is upgraded in the process. Log shipping requires that the secondary database be a read-only exact copy of the primary database, the changes made by the upgrade would make this impossible.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply