This topic describes the Database Engine features that are no longer available in SQL Server 2008.

Category	Discontinued feature	Replacement
Aliases	sp_addalias	Replace aliases with a combination of user accounts and database roles. For more information, see CREATE USER (Transact-SQL) and CREATE ROLE (Transact-SQL). Remove aliases in upgraded databases by using sp_dropalias.
APIs	Registered Servers API	Replaced by a new registered servers API that supports new SQL Server 2008 features.
Backup and restore	DUMP statement	BACKUP
Backup and restore	LOAD statement	RESTORE
Backup and restore	BACKUP LOG WITH NO_LOG	None. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model.
Backup and restore	BACKUP LOG WITH TRUNCATE_ONLY	None. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model.
Backup and restore	BACKUP TRANSACTION	BACKUP LOG
Compatibility level	60, 65, and 70 compatibility levels	Databases must be set to at least compatibility level 80.
DBCC	DBCC CONCURRENCYVIOLATION	None
Groups	sp_addgroup	Use roles.
Groups	sp_changegroup	Use roles.
Groups	sp_dropgroup	Use roles.
Groups	sp_helpgroup	Use roles.
Sample databases	Northwind and pubs	Use AdventureWorks. Northwind and pubs are available as downloads, or can be copied from a previous installation of SQL Server. For more information, see AdventureWorks Sample Databases.
Tools	Surface Area Configuration Tool	The Surface Area Configuration Tool is discontinued for SQL Server 2008. For more information, see Backward Compatibility.
Web Assistant	sp_makewebtask sp_dropwebtask sp_runwebtask sp_enumcodepages	We recommend that you use SQL Server Reporting Services instead.

See Also