How can we help you today? How can we help you today?

Log ship to different server version

Can I setup log shipping to ship from a SQL 2000 source server to a SQL 2005 destination server ?

Cheers,

Cameron
cameron.gibbs
0

Comments

1 comment

Sort by
  • Matthew Flatt
    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
    0

Add comment

Please sign in to leave a comment.