Contains one row for each restore operation. This table is stored in the msdb database.
Column name | Data type | Description |
---|---|---|
restore_history_id | int NOT NULL IDENTITY PRIMARY KEY | Unique identification number identifying each restore operation. |
restore_date | datetime NULL | Date and time of the restore operation. |
destination_database_name | nvarchar(128) NULL | Name of the destination database for the restore operation. |
user_name | nvarchar(128) NULL | Name of the user who performed the restore operation. |
backup_set_id | int NOT NULL REFERENCES backupset(backup_set_id) | Unique identification number identifying the backup set being restored. |
restore_type | char(1) NULL | Type of restore operation: D = Database F = File G = Filegroup L = Log V = Verifyonly |
replace | bit NULL | Indicates whether the restore operation specified the REPLACE option: 1 = Specified 0 = Not specified |
recovery | bit NULL | Indicates whether the restore operation specified the RECOVERY or NORECOVERY option: 1 = RECOVERY 0 = NORECOVERY |
restart | bit NULL | Indicates whether the restore operation specified the RESTART option: 1 = Specified 0 = Not specified |
stop_at | datetime NULL | Point in time to which the database was recovered. |
device_count | tinyint NULL | Number of devices involved in the restore operation. This number can be less than the number of media families for the backup. |