| title | restorefilegroup (Transact-SQL) | ||
|---|---|---|---|
| description | restorefilegroup (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 03/03/2017 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
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.
Backup and Restore Tables (Transact-SQL)
restorefile (Transact-SQL)
restorehistory (Transact-SQL)
System Tables (Transact-SQL)