Moving All Databases to a new Server

  • Follow


Currently have databases for 2007 sitting on standalone SQL Server 2005 
default instance. We'd like to move them to a new SQL Server 2008 cluster.
We've been looking at http://technet.microsoft.com/en-us/library/cc512725.aspx
and a question came up. The article lists two scenarios
 -- you move to a server with the same name
 -- you move to a server with a different name

We're considering a scenario where 
 -- you create a sql cluster with a SQL Cluster network name = to original 
server name
 -- install default instance
 -- Use the "move to a server with the same name" process to migrate the 
databases. 

Has anyone done this or have advice?



 

-- 
peter feakins
0
Reply Utf 4/22/2010 3:04:02 PM


0 Replies
292 Views

(page loaded in 0.4 seconds)

Similiar Articles:
















7/23/2012 7:48:15 AM


Reply: