Log Shipping between two versions of SQL Server

  • I'm pretty sure that the answer to this is no, but I just want confirmation from someone else...it's not possible to configure log shipping between a 2000 server and 2005/8 server, right?

  • you will have to write your own custom process but you can log ship to a higher version, You will have to leave the database in norecovery mode, the standby option will not be available.

    I would not do this for any other reason than reducing the outage time when upgrading a database onto a new server (side by side upgrade). As a setup its no use for a reporting server and if for DR or HA your failover server should be the same version as the primary.

    ---------------------------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply