January 22, 2019 at 5:13 am
I have been working SQL for a while but never had to do this so apologies as it is something that has come up numerous times but I want to get a grip on it.,
I have a SQL Environment 1 Instance that is in a cluster. it is running on 2008.
II am going to build another cluster in a different location contactable from the other.
The Databases are large about 2tb each and i have a limited time to migrate.
What i wanted to do is to restore the backups from he night previous to the new environment (2012 SQL to 2016 SQL) and i wanted to just copy the changes from one db to the other to keep them in sync and i have never done this before.
Can anyone enlighten me as to the best way to do this?
January 22, 2019 at 7:19 am
Andrew.weckermann - Tuesday, January 22, 2019 5:13 AMI have been working SQL for a while but never had to do this so apologies as it is something that has come up numerous times but I want to get a grip on it.,I have a SQL Environment 1 Instance that is in a cluster. it is running on 2008.
II am going to build another cluster in a different location contactable from the other.
The Databases are large about 2tb each and i have a limited time to migrate.
What i wanted to do is to restore the backups from he night previous to the new environment (2012 SQL to 2016 SQL) and i wanted to just copy the changes from one db to the other to keep them in sync and i have never done this before.
Can anyone enlighten me as to the best way to do this?
You can configure and migrate everything to the new server - logins,jobs, linked server etc.
Do a full backup and restore with norecovery mode and make sure there is no full backup after that on the old server.
You can restore a differential as well with norecovery - otional
Place the database into read only or single user mode and take a final log backup. -- cut over to make sure no updates
Restore a log backup to the new server with recovery and verify everything.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply