Yes log shipping can be setup to ship from a SQL 2000 database to a SQL 2005 database, there are a couple of points to note though :
You must set the SQL 2005 database to be in NO RECOVERY mode, the WITH STANDBY option will not work because the database must be upgraded to SQL 2005 before it can be queried.
SQL Server performs this upgrade when the Database is brought Online.
Because SQL Server performs these upgrade steps when bringing the database online, you should be aware that it might take longer to bring the database online that a straight 2000 -> 2000 etc log shipping scenario.
You should factor this into any disaster recovery plans/response times you may have.
cameron.gibbs
Posts: 18
Comments
Yes log shipping can be setup to ship from a SQL 2000 database to a SQL 2005 database, there are a couple of points to note though :
You must set the SQL 2005 database to be in NO RECOVERY mode, the WITH STANDBY option will not work because the database must be upgraded to SQL 2005 before it can be queried.
SQL Server performs this upgrade when the Database is brought Online.
Because SQL Server performs these upgrade steps when bringing the database online, you should be aware that it might take longer to bring the database online that a straight 2000 -> 2000 etc log shipping scenario.
You should factor this into any disaster recovery plans/response times you may have.
I hope this helps.
Redgate Foundry