Transact-SQL Reference
restorefile
The restorefile table 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. |