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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!