I am moving our SQL Server databases to a new machine. The old OS is Windows 2000 and the new is Windows Server 2003. The version of SQL Server is staying the same and the data folder structure will be the same. My question is: Would it work to install SQL Server on the new machine, stop the services on both machines and then simply copy the data folders from the old to the new. Then start the services on the new and be up and running. Rather than restoring databases from back up or detach/attach all the databases?
June 13, 2006 4:44 PM
June 16, 2006 10:28 AM