Applies to: SQL Server (all supported versions)
Contains one row for each restored filegroup. 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).|
|filegroup_name||nvarchar(128)||Name of the filegroup being 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.