LOAD

Transact-SQL Reference

Transact-SQL Reference

LOAD

Loads a backup copy of one of the following:

  • User database (LOAD DATABASE)

  • Transaction log (LOAD TRANSACTION)

  • Header information about the dump (LOAD HEADERONLY)

Important  The LOAD statement is included in Microsoft® SQL Server™ 2000 for backward compatibility. The LOAD statement is identical to the RESTORE statement. It is recommended that the RESTORE statement be used instead of the LOAD statement. In a future version of SQL Server, LOAD will not be supported.

See Also

BACKUP

CREATE DATABASE

RESTORE

sp_helpdevice