joshua.post (6/6/2013)
Is backing up the databases and restoring the best way, including Master and Model, or once the old server is shut down, can I just copy the files over? MDF etc?In the cluster, can I just delete the cluster resources for the IP and computer name but leave SQL running?
What about moving over the SQL Integration Services components?
All of your agent jobs will come over when you restore msdb. You can also script the jobs out on the old server and re-create on the new.
For integration services you can export the packages on the old server first by connecting to Integration Services via SSMS and right clicking on the package and choosing export.
On the new server connect to Integration Services via SSMS and if they packages were stored in msdb right click on it and choose import package. If you didn't export them you can connect directly to the old instance and import them. If not point to the file you export previously.
If the packages were on the file system on the old server you should just be able to copy them to the same path on the new server.
Since you are upgrading to 2008 I'd open the packages in BIDS and save them so they get upgraded. If the server names stay the same you shouldn't have to modify the connections in the package. If they changed and the old name was hard coded you may have to edit the package.
If you were using maintenance plans on the old server I would re-create them from scratch on the new 2008 server.