restorehistory (T-SQL)

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.


(c) 1988-98 Microsoft Corporation. All Rights Reserved.