Backup and Restore (Level 3)

Installing SQL Server

Installing SQL Server
Backup and Restore (Level 3)
SQL Server 6.x SQL Server 2000
The DUMP statement created database or transaction log backups (dumps). The DUMP DATABASE and DUMP TRANSACTION statements are synonymous with BACKUP DATABASE and BACKUP LOG statements. Support for the DUMP DATABASE and DUMP TRANSACTION statements may be removed in a future release.

Consider removing all references of DUMP DATABASE and replacing with references to BACKUP DATABASE. Consider removing all references of DUMP TRANSACTION and replacing with references to BACKUP LOG.

The LOAD statement restored or loaded database or transaction log backups (dumps). The LOAD DATABASE and LOAD TRANSACTION statements are synonymous with the RESTORE DATABASE and RESTORE LOG statements. Support for the LOAD DATABASE and LOAD TRANSACTION statements may be removed in a future release.

Consider removing all references of LOAD DATABASE and replacing with references to RESTORE DATABASE. Consider removing all references of LOAD TRANSACTION and replacing with references to RESTORE LOG. For more information about RESTORE DATABASE, see RESTORE.

The CREATE DATABASE ...FOR LOAD statement syntax created a destination database before its restoration from a database backup and prevented anyone from using the database between the CREATE DATABASE, ALTER DATABASE, and LOAD statements. The CREATE DATABASE ...FOR LOAD syntax is supported for backward compatibility only. However, because SQL Server now creates the destination database within a restore operation, it is recommended that the destination database not be created before executing the restore operation.

Do not create the database prior to restoring it.