Hi we are planning to move our SQL Server default instance (only instance running) to another machine as an upgrade.
I don't want to lose my SQL logins and Agent jobs and was wondering if it's as simple as detaching and attaching the system databases (like master, msdb, model, tempdb) .
If there are any articles on SQL Server Central, that'll be helpful too. Thanks!
old machine had Windows 2003 R2 Enterprise x86 OS and SQL Server 2008 R2 Enterprise x86
new machine is Windows 2008 R2 x64 and SQL Server 2008 R2 Enterprise x64
Both Intel Xeon platforms