I am not a DBA/server admin, and unfortunately we don't really have any currently. My organization wants to move a SQL server 2008 instance running on Windows Server 2003 (physical) over to 2008R2 running on Windows Server 2008 (Virtual).
I am wondering if there are any tools that would make this process as painless as possible? We want to move over everything icluding logins, SQL agent jobs, etc if possible. It looks like we could use the built-in Copy Database Wizard to move the databases themselves, but how about the other server objects?