We're replacing our Windows NT server running SQL 2000 with newer hardware running Windows Server 2003 but still SQL 2000. What is the easiest way to do this?
We know how to copy the normal databases etc either by backup and restore or moving and reattaching the data files but we also need to copy logins, DTS packages, SQL Agent jobs etc. We've found instructions on how to do this using DTS packages although it seems kind of complicated to avoid orphaned logins etc.
Given that we just want to copy everything, could we copy the system databases and therefore bring everything over in one bucket so to speak? I haven't really found any info to indicate whether this is possible or if there is too much O/S and other installation specific stuff in the system databases for that to work.