September 2, 2014 at 12:02 am
Hi,
Usually when in the process of migration, how to calculate how much time it will take to migrate the database. If a database full backup is taking approximately 3 hr how much time it will take to restore that database.
Which process is better to migrate the SQL server from 2008 to 2014.
Database migration wizard or restoring the db using backup file?
Usually if you are new to the sql server and you don't have any idea about the OS how can you find how much time it will take for migration for each database and for all databases
September 2, 2014 at 1:48 am
The only way would be to test it out, if you know the time for the backup, then you can time the restore on the new server.
There is more to migration than restoring the database, the indexes and statistics need to be updated, all jobs / logins / linked servers / database mail / Server wide DDL triggers etc etc all have to be recreated.
Which is better again test it out. My preferred method is backup and restore, its tried and tested.
September 2, 2014 at 6:48 am
What you could do is use mirroring or log shipping to perform your migration, you could backup & restore your database(s) onto the new server before you intend to migrate. Then when you migrate it would simply be a matter of either failing over (with mirroring) or bringing the database online (log shipping).
That way you take the hit on time for the migration before the actual process.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply