The Restore object defines the behavior of a RESTORE statement for a Microsoft® SQL Server™ database or log.
With the Restore object you can:
SQL Server can write a backup to one of four media types: disk, tape, named pipe, or a proprietary media called a backup device. SQL Server supports backup striping. A striped backup is one directed to more than a single device. Striping is supported to a single media type only. That is, a backup can be written to two tape devices. A backup cannot be written half to a tape device and the other half to a disk.
At a minimum, you must supply values for a restore source when using the Restore object. SQL-DMO implements supported media types in the Restore object properties Files, Devices, Pipes, and Tapes. Use one media type property to specify the restore operation source.
Setting other properties in the Restore object may be required by the restore operation desired. For example, before using the SQLRestore method, the Database property of the Restore object must be set.
To perform a complete database restore
To restore a single unit of a database log
To restore a database log chain
To verify the integrity of backup media
Abort Method | ReadMediaHeader Method (Restore) |
GenerateSQL Method (Backup, Restore) | SQLRestore Method |
ReadBackupHeader Method (Restore) | SQLVerify Method |
ReadFileList Method |
Complete Event | PercentComplete Event |
NextMedia Event |