New answers tagged vldb
Hi best option is to to use backup restore. It will keep minimum down time This is safe as your database at 2008 will be available till your 2012 is ready you can do comparison testing for few days you can make sure if there is any issues in 2012 you can take your business back to 2008 and avoid worst situation till all check from app is done
First you need to run upgrade advisor to be able to confirm that there won't be any errors during the upgrade from 2008 to 2012. If you want to minimize downtime, then setup mirroring from SQL 2008 to 2012 (yes mirroring is still supported but declared deprecated). Then during the day of cutover (migration), change the mode of mirroring to SYNCHRONOUS and ...
Top 50 recent answers are included