.png)
restorefilegroup (Transact-SQL)
SQL Server 2012
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.
