What are the challenges you face when working across database platforms? Take the survey
Options

Log ship to different server version

cameron.gibbscameron.gibbs Posts: 18
edited October 10, 2008 4:44AM in SQL Backup Previous Versions
Can I setup log shipping to ship from a SQL 2000 source server to a SQL 2005 destination server ?

Cheers,

Cameron

Comments

  • Options
    Hi Cameron,

    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.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.