restorefilegroup (Transact-SQL)

Applies to: yesSQL 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.

Remarks

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

See Also

Backup and Restore Tables (Transact-SQL)
restorefile (Transact-SQL)
restorehistory (Transact-SQL)
System Tables (Transact-SQL)