Move SQL Server 2005 installation to a new server

• gtjuri

  SSC Journeyman

  Points: 98

  More actions

  July 9, 2008 at 5:21 am

  #193539

  Hi

  what is the best way to move the whole SQL Server 2005 Enterprise installation including all db's on server 1 and SQL Server 2000 Enterprise installation with all db's on server 2 to a new SQL Server 2005 Enterprise server 3?

  Thanks

  Juri

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  July 25, 2008 at 6:45 am

  #848340

  If you can live with some downtime, detach/attach is the simplest method.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com