restorefile

Transact-SQL Reference

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.