restorefilegroup-transact-sql.md

title	restorefilegroup (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	restorefilegroup_TSQL restorefilegroup
dev_langs	TSQL
helpviewer_keywords	filegroups [SQL Server], restorefilegroup system table restorefilegroup system table
ms.assetid	3aa15c55-6b72-4f76-97d7-bd88391d105c
author	stevestein
ms.author	sstein

restorefilegroup (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)