LOAD (T-SQL)

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™ version 7.0 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.

BACKUP	RESTORE
CREATE DATABASE	sp_helpdevice

LOAD (T-SQL)

See Also