June 8, 2012 at 5:18 am
Hi,
I have my SERVER01 SQL Server 2008 server with many databases. Now we need migrate this server to a new SERVER02 (also with SQL Server 2008); the server SERVER01 will shut down when the migration is complete. We need to move all existing databases in SERVER01 with a minimum downtime (because existing application are critical).
I know that there are many ways/tecniques to migrate/move databases from SERVER01 to SERVER02, such as, backup/restore, detach/atach databases, export/import etc ... but with all of them the downtime is very high for me (because as i say later the application are critical).
Somebody say me how i can sincronize SERVER01 databases with SERVER02 databases while the users are working in SERVER01 (the idea is to shut down the SERVER01 when sincronizing process between SERVER01 and SERVER02 is complete and the users will work with the new SERVER02 -i only have to change the database connection string and the downtime will be very short)?
Many thanks in advance.
June 8, 2012 at 6:22 am
Logshipping is an option. Set it up, then when your ready to migrate, simply backup Server1's database logs with norecovery, and then restore that log on Server2 with recovery. Then you need to ensure things like jobs, logins etc are all set ready to go.
Replication as well is an option, again jobs logins, server objects need to be manually copied.
June 8, 2012 at 6:25 am
Many thanks Anthony.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply