December 2, 2005 at 4:56 pm
Check out log shipping under sql server 2005 Books Online -- doesn't appear to me that log shipping can work between two different versions of sql server.
"You cannot directly upgrade a SQL Server 2000 log shipping configuration to SQL Server 2005. The Database Maintenance Plan Wizard, which was integral to log shipping in SQL Server 2000, is not used as part of the log shipping configuration in SQL Server 2005. As a result, log shipping stops functioning when you upgrade a server to SQL Server 2005."
You can migrate a SQL Server 2000 log shipping configuration while maintaining synchronization between your primary and secondary databases. This topic describes two methods of doing this....
After you have deployed a new log shipping configuration, you can remove the SQL Server 2000 log shipping tables and jobs that may still be on your computer.
SQL Server 2005 does not use any of the log shipping tables used by SQL Server 2000. You can therefore delete these tables after you upgrade your server to SQL Server 2005:
log_shipping_databases
log_shipping_monitor
log_shipping_plan_databases
log_shipping_plan_history
log_shipping_plans
log_shipping_primaries
log_shipping_secondaries
You can also delete any log shipping SQL Server Agent jobs that were created by SQL Server 2000.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply