ReadBackupHeader Method

SQLServer Object

Description

Retrieves the dump header information for a Backup object. The dump header contains information about every dump currently stored in the dump device. The dump header information is returned in a QueryResults object.

Visual Basic

QueryResults = SQLServer.ReadBackupHeader ( [LoadSpec :=] Backup )

C++

HRESULT pSQLServer->ReadBackupHeader (
LPSQLOLEBACKUP
Backup,
LPSQLOLEQUERYRESULTS*
ppQueryResults );

Element Type Description

QueryResults QueryResults Returned QueryResults object
Backup Backup Backup object containing the backup specifications

QueryResults

ColumnName ColumnType

Dumptype SQLOLE_DTypeInt2
Database SQLOLE_DTypeChar
Striped SQLOLE_DTypeInt2
Compressed SQLOLE_DTypeInt2
Sequence SQLOLE_DTypeChar
Volume SQLOLE_DTypeChar
Devicetype SQLOLE_DTypeInt2
Table SQLOLE_DTypeChar
Dumpsize SQLOLE_DTypeChar
Stripeset SQLOLE_DTypeChar
Stripeset Name SQLOLE_DTypeChar
Curseq SQLOLE_DTypeChar
Newseq SQLOLE_DTypeChar
CreationDate SQLOLE_DTypeChar
CreationTime SQLOLE_DTypeChar
ExpireDate SQLOLE_DTypeChar

Reference

LOAD HEADERONLY