LoadHistory Property

SQL-DMO

SQL-DMO

LoadHistory Property

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

Applies To
Restore Object
Syntax

object.LoadHistory [= value]

Parts

object

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.