• Article

LoadHistory Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The LoadHistory property configures Restore object action when the object is used to verify the integrity of a Microsoft SQL Server backup.

Syntax

object
.LoadHistory [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLoadHistory(LPBOOL pRetVal);
HRESULT SetLoadHistory(BOOL NewValue);

Remarks

If TRUE, msdb backup history tables are updated with backup set data when the SQLVerify method of the Restore object directs backup set verification.

If FALSE, history tables are not altered when SQLVerify is used.

Applies To:

Restore Object