I have Windows server 2003 std/SQL server 2000 std server that I'm going to do an "In place" upgrade on to bring it to SQL Server 2008 std R2. (Presuming everything goes well with that...) I have another server I will setting up as Windows server 2008 std R2 / SQL server 2008 std R2 (32 bit SQL- same as before on SQL 2000).
With the SQL server software "stopped", can I hook a crossover cable between the 2 servers and copy the entire contents from Program Files\Microsoft SQL Server\MSSQL\Data folder from the Windows 2003\SQL 2008 (upgraded) machine to the "Data" folder on the Windows 2008\SQL 2008 and everything be fine with SQL server?
This is how I've always done it on SQL 2000 to go from an old server to a new server and it has always worked. Just wondering if that still applies in SQL 2008?