| title | restorefile (Transact-SQL) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/03/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine | |||
| ms.reviewer | ||||
| ms.technology | system-objects | |||
| ms.topic | language-reference | |||
| f1_keywords |
|
|||
| dev_langs |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | 8e40145a-8559-4abe-8e2a-39b818928009 | |||
| author | stevestein | |||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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. |
To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.
Backup and Restore Tables (Transact-SQL)
restorefilegroup (Transact-SQL)
restorehistory (Transact-SQL)
System Tables (Transact-SQL)