- Compressed Backup
- AUDITING => Change Data Capture (CDC)
- FileStream
- Sparse Column Support
- Performance Data Management
- Encryption => Transparent data encryption (TDE)
- Resource Governor
- Freeze Plan
- 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
