Export (0) Print
Expand All

restorefilegroup (Transact-SQL)

Contains one row for each restored filegroup. This table is stored in the msdb database.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Community Additions

ADD
Show:
© 2014 Microsoft