LOAD (Transact-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 for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use RESTORE (Transact-SQL) and RESTORE HEADERONLY (Transact-SQL).
BACKUP (Transact-SQL)
CREATE DATABASE (Transact-SQL)
sp_helpdevice (Transact-SQL)