LOAD Statement Summary

You can load a database or apply a transaction log by using either SQL Enterprise Manager or the LOAD statement. However, some operations can be performed only by using the LOAD statement. This is the syntax for the LOAD statement.

Syntax

Loading a database:

    LOAD DATABASE {dbname | @@dbname_var}
        FROM dump_device [, dump_device2 [..., dump_device32]]
    [WITH options
        [[,] STATS [ = percentage]]]

Loading a transaction log:

    LOAD TRANSACTION {dbname | @@dbname_var}
        FROM dump_device [, dump_device2 [..., dump_device32]]
    [WITH options]

Loading header information:

    LOAD HEADERONLY
        FROM dump_device

where

dump_device =

{ dump_device_name | @@dump_device_namevar}
| {DISK | TAPE | FLOPPY | PIPE} =
{'temp_dump_device' | @@temp_dump_device_var}}
[VOLUME = {volid | @@volid_var}]

options =

[[,] {UNLOAD | NOUNLOAD}]
[[,] {SKIP | NOSKIP}]
[[,] {FILE = fileno}]

For more information¾including explanations of each parameter and option¾see the discussion of the LOAD Statement in the Microsoft SQL Server Transact-SQL Reference.