|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Mirroring SQL serversI am in the process of changing from SQL server A to SQL server B but the
databases are huge. Can I mirror A with B then just turn off A when its completed? What steps would be involved here? Thanks! Jon One process I have seen is to take a full backup on A, restore on B, then
apply transaction logs from A to B on a schedule (e.g. every 15 minutes) until you are caught up, so you can get down to a narrow enough window to flip the switch. Hopefully your references to the database server are relatively dynamic and you can switch them all on command (as opposed to server names embedded in applications, requiring deployment everywhere)... you just may want to wait for the final switch until you can have a maintenance window and shut users out of the app(s)... A Show quote "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message news:0qEWe.23146$uD6.16086@tornado.ohiordc.rr.com... >I am in the process of changing from SQL server A to SQL server B but the >databases are huge. Can I mirror A with B then just turn off A when its >completed? What steps would be involved here? > > Thanks! > Jon > Jon,
To add to Aaron's reponse...be sure to account for any server name and IP address changes to ensure applications continue to work as expected. HTH Jerry Show quote "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:eBE8L$uuFHA.3764@TK2MSFTNGP09.phx.gbl... > One process I have seen is to take a full backup on A, restore on B, then > apply transaction logs from A to B on a schedule (e.g. every 15 minutes) > until you are caught up, so you can get down to a narrow enough window to > flip the switch. Hopefully your references to the database server are > relatively dynamic and you can switch them all on command (as opposed to > server names embedded in applications, requiring deployment everywhere)... > you just may want to wait for the final switch until you can have a > maintenance window and shut users out of the app(s)... > > A > > > "Jon Glazer" <jglazer.delete***@adconn.com> wrote in message > news:0qEWe.23146$uD6.16086@tornado.ohiordc.rr.com... >>I am in the process of changing from SQL server A to SQL server B but the >>databases are huge. Can I mirror A with B then just turn off A when its >>completed? What steps would be involved here? >> >> Thanks! >> Jon >> > > > To add to Aaron's reponse...be sure to account for any server name and IP Yes, it may make sense to utilize a hosts file or internal DNS, for example > address changes to ensure applications continue to work as expected. if you have database server names embedded in your apps you can always fake them out by redirecting to a different IP. However, this won't work for all things, e.g. if you reference linked servers etc. you will have to worry about changing those and anything you configured in the client network utility. Long story short, there are a lot of variables, but plenty of shortcuts too. A  |
|||||||||||||||||||||||
Other interesting topics