Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
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)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount.
Register today