was working on upgrade from SQL 2000 to SQL 2008 and up to this point everything is going well , untill came to the live implemnation redirect all application to point to the new destination "SQL 2008" and in our meeting with managment they asked the common
questions "WHAT IF" after a while we dicoverd smth wrong and was a necessery to downgared to SQL 2000 aagain ?? actually I couldn't figuer a way to answer accordingly they posponted the LIVE implemnation untill figuer out a way make us able to rollback safely
since we are running with too critical db ..banking system db and "LIVE MONEY TRANSACTION" .. So please is there any safely way to do this with the highest grantee of Rollback will work smothly
Aslo please note that i though to implement transaction replication from SQL 2008 to SQL 200 but with many database like I have will be very hard to monitor around 80 db replicate....
View Complete Post