February 13, 2013 at 5:47 am
Hi All,
Assuming my database server is 24*7 database, what would be the best strategy to migrate my database server to new server with new hardware with minimal downtime?
Thanks in advance.
February 13, 2013 at 8:11 am
Use mirroring. Not the SQL 2005 but the idea is the same eg: http://www.solidq.com/gl-en/News/Pages/Case-Study-Payvision-Migrates-to-SQL-Server-2008-with-Only-4-Seconds-of-Database-Downtime.aspx
February 13, 2013 at 9:10 am
Thanks a ton.
February 14, 2013 at 9:42 am
If there is no database mirrorning implement and incase i cannot implement mirroring on all databases on production , i such a scenario what would be the best way to perform the migration to new server with minimal downtime ?
February 15, 2013 at 3:12 pm
Database mirroring is also a good option but there is a limit on how many databases you can mirror. I would recommend using log shipping to do the migration if your servers are hosting large number of databases. I have used Log shipping to migrate hundreds of databases from one location to another.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply