Upgrade from SQL 2000 - 2008 - Log Submission
I am in the process of upgrading from SQL 2000 - SQL 2008 It would be possible (or feasible) to set up log shipping from Server A, which has an sql 2000 database, to Server B, with an instance of SQL 2008 on
Or is there a better way to update?
I need to explicitly test my application using a new instance of SQL 2008 ....
source to share
You can customize and script the steps that are required manually, since the log upload is just a copy of the transaction log file taken from the primary server, which is sent to the secondary server and then subsequently restored. Just make sure the database compatibility level of the SQL Server 2008 database is set appropriately.
I suspect, however, that you will not be able to configure log shipping using the Wizard in SQL Server 2000, however I am not sure about that. Of course, you could check it out pretty easily.
So, to be clear, you can register a ship downstream from SQL Server 2000 to SQL Server 2008, but you cannot register Ship downstream from SQL Server 2008 to SQL Server 2000
If you want to upgrade your log shipping configuration on SQL Server 2000 to SQL Server 2008, see the following Microsoft Reference
source to share