If the database servers are the same version (or the database your migrating from is a lower version), I would just do a backup and restore to the new server. This is by far, the easiest mechanism by which to get all the data, users, and structure from one server to another. How much downtime are you factoring in for the server move? How many databases do you have to deal with? You should be able to backup a 75 GB database in around 5 minutes -- Jeff -------- Original Message -------- > From: "C. Hatton Humphrey" <[email protected]> > Sent: Wednesday, October 01, 2014 7:00 AM > To: "cf-community" <[email protected]> > Subject: Migrating SQL Servers - Best practices? > > We're rebuilding our network infrastructure and this includes rebuilding > one web/data and one puer data server from scratch. The apps require MS > SQL Server up to 2008 so that's what has been installed. The databases on > the pure data server are huge in some cases (75gb). > > If you had time (we're 2 weeks from launch but the servers are up now) and > a dedicated pipe, what would be your prefered method to ship the data > over? I'm thinking something like mirroring but have never done it. > > Thoughts? > > Until Later! > C. Hatton Humphrey > http://www.eastcoastconservative.com > > Every cloud does have a silver lining. Sometimes you just have to do some > smelting to find it. > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:372728 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
