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 <j...@garzasixpack.com> 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" <chumph...@gmail.com> > > Sent: Wednesday, October 01, 2014 7:00 AM > > To: "cf-community" <cf-community@houseoffusion.com> > > 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:372729 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
