Sql Server 2008 Features

Following features are available in SQL server 2008

1.Compressed Backup
2.AUDITING => Change Data Capture (CDC)
3.FileStream
4.Space Column Support
5.Performance Data Management
6.Encryption => Transparent data encryption (TDE)
7.Resource Governor
8.Freeze Plan
9.LINQ Support

Deprecated Features in future realases (but still available in Sql 2008)

BACKUP {DATABASE | LOG} WITH PASSWORD
BACKUP {DATABASE | LOG} WITH MEDIAPASSWORD
RESTORE {DATABASE | LOG} … WITH DBO_ONLY
RESTORE {DATABASE | LOG} WITH PASSWORD
RESTORE {DATABASE | LOG} WITH MEDIAPASSWORD