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.