One of the best features of SQL Server 2005 & 2008 that I like is that it lets you perform restore on portions of the database which is damaged and yet keep the database ONLINE. This was not possible with earlier versions of SQL Server. In SQL Server 2005/2008, you no longer have to take the database offline to perform a restore on a small portion of a database. Once you have identified the pages that need to be restored you have two options:

1) You can perform a PAGE level restore (My recommendation is to do this when you have small number of pages)

2) You can perform a FILE level restore (My recommendation is to do this when you have large number of pages)