I just started a new dba job and have been given a new server and told to move everything from the old server to the new one, brand new windows and SQL Server installations. I know I have to transfer user databases, logins, SSIS packages and maintenance plans.
- Is there anything else I should be aware of to move. Both instances are SQL Server 2008 R2.
- Is there an easier way to move the maintenance plans other than scripting each one and applying these to the new server?
Thanks for your help.