I'm planning to upgrade a SQL server 7 database to a new server with SQL 2005 soon.
I will follow the migration path for the upgrade and my question has to do with my back-out plan.
When we go live on a Monday morning, I will leave my SQL server 7 box n stand-by mode in case anything goes wrong with the new server.
Is there a way to get the new data back into my stand-by SQL server 7 in case the new SQL 2005 server has issues after going live
Let's say the new server runs for two hours and I need to revert back to my SQL 7 server, What would be the best approach for this scenario
Thanks
Alfonzo
Upgrade from SQL 7 to SQL 2005
Ceres629
You will need to keep the SQL7 server updated or provide a way to move the data from SQL 2005 back to SQL 7. Integrations Services is likely your best option or a custom tool that you create. Options like backup/restore or attach/detach will not work.
Thanks,
Peter Saddow