Actually, thinking about this a bit more... It might be even easier to simply detach the database, copy it over then re-attach on the new server.
It's the same basic process, but you are omitting the back-up which isn't really necessary if you're able to take the system down during the transition. -- Jeff -------- Original Message -------- > From: "William Bowen" <[email protected]> > Sent: Wednesday, October 01, 2014 10:13 AM > To: "cf-community" <[email protected]> > Subject: Re: Migrating SQL Servers - Best practices? > > Definitely agree with Jeff here. > > If the version is the same, then Backup/Restore. > > If the version is 2005 or 2000, then: > http://msdn.microsoft.com/en-us/library/ms177429(v=sql.105).aspx > > Also agree that the 75GB database shouldn't be too much trouble. > > On Wed, Oct 1, 2014 at 9:23 AM, Jeff Garza <[email protected]> wrote: > > > > > 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:372731 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
