Export (0) Print
Expand All

restorehistory (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Contains one row for each restore operation. 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 each restore operation. Identity, primary key.

restore_date

datetime

Date and time of the completion of the restore operation. Can be NULL.

destination_database_name

nvarchar(128)

Name of the destination database for the restore operation. Can be NULL.

user_name

nvarchar(128)

Name of the user who performed the restore operation. Can be NULL.

backup_set_id

int

Unique identification number identifying the backup set being restored. References backupset(backup_set_id).

restore_type

char(1)

Type of restore operation:

D = Database

F = File

G = Filegroup

I = Differential

L = Log

V = Verifyonly

Can be NULL.

replace

bit

Indicates whether the restore operation specified the REPLACE option:

1 = Specified

0 = Not specified

Can be NULL.

When a database is reverted to a database snapshot, 0 is the only option.

recovery

bit

Indicates whether the restore operation specified the RECOVERY or NORECOVERY option:

1 = RECOVERY

Can be NULL.

When a database is reverted to a database snapshot, 1 is the only option.

0 = NORECOVERY

restart

bit

Indicates whether the restore operation specified the RESTART option:

1 = Specified

0 = Not specified

Can be NULL.

When a database is reverted to a database snapshot, 0 is the only option.

stop_at

datetime

Point in time to which the database was recovered. Can be NULL.

device_count

tinyint

Number of devices involved in the restore operation. This number can be less than the number of media families for the backup. Can be NULL.

When a database is reverted to a database snapshot, the number is always 1.

stop_at_mark_name

nvarchar(128)

Indicates recovery to the transaction containing the named mark. Can be NULL.

When a database is reverted to a database snapshot, this value is NULL.

stop_before

bit

Indicates whether the transaction containing the named mark was included in the recovery:

0 = Recovery halted before marked transaction.

1 = Recovery included marked transaction.

Can be NULL.

When a database is reverted to a database snapshot, this value is NULL.

To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft