There are loads of add-ins and management stuff from Microsoft and other vendors to make taking care of SQL Server easier, and in case you haven’t noticed SQL Server 2008 has now been released so will those tools work with the new version?
For the most part the answer is yes as SQL Server 2008 is more of the same stuff that was in SQL Server 2005, but there are new features as well. So the various tools will have to change to reflect the new features so you can get the benefit of upgrading.
In the Microsoft world some of these add-ins and feature packs are already available to make our management tools SQL Server 2008 aware:
Similarly the main tools vendors Idera, Quest and Red-Gate all have extensive support for SQL Server 2008 already.
Backing up a cube is not an ideal experience in SQL Server 2005 for two reasons, it’s a manual process