restorefile (Transact-SQL)

Applies to: SQL Server

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	Unique identification number that identifies the corresponding restore operation. References restorehistory(restore_history_id).
file_number	numeric(10,0)	File identification number of the restored file. This number must be unique within each database. Can be NULL. When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.
destination_phys_drive	nvarchar(260)	Drive or partition to which the file was restored. Can be NULL. When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.
destination_phys_name	nvarchar(260)	Name of the file, without the drive or partition information, where the file was restored. Can be NULL. When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.

Remarks

To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.