SQL Server 2000
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.|