So I am moving from a physical server to a VM MS SQL Server 2005 and am planning to detach and attach the databases to the new server. Here are my questions. :-)
Here is the setup:
Existing: MS Server 2003 32-Bit, MSSQL Server 2005 SP3,
New: MS Server 2008 64-Bit, MSSQL Server 2005 SP3,
- Should I detach system databases before detaching all of the user databases?
- Should I attach the system databases before or after all of the user databases?
- Should I export the login's using this information before transferring any databases?
Thank you in advance for all of your help!