Contains one row for each restored file, including files restored indirectly by filegroup name. This table is stored in the msdb database.
Column name | Data type | Description |
---|---|---|
restore_history_id | int NOT NULL REFERENCES restorehistory(restore_history_id) | Unique identification number identifying the corresponding restore operation. |
file_number | numeric(10,0) NULL | File identification number of the restored file. This number must be unique within each database. |
destination_phys_drive | varchar(260) NULL | Drive or partition to which the file was restored. |
destination_phys_name | varchar(260) NULL | Name of the file, without the drive or partition information, where the file was restored. |