Jaa

SQLVerify Method

  • Artikkeli

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 SQLVerify method checks the backup media specified, ensuring that a backup set is readable and complete.

Syntax

object
.SQLVerify(
SQLServer
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • SQLServer
    SQLServer object connected to an instance of Microsoft SQL Server on which the backup media is visible.

Prototype (C/C++)

HRESULT SQLVerify(LPSQLDMOSERVER ServerObject);

Remarks

The SQLVerify method does not perform a restore of any SQL Server database or transaction log.

To validate the integrity of a SQL Server backup

  1. Create a SQLServer object.

  2. Connect the SQLServer object to an instance of SQL Server on which the source backup device is visible.

  3. Create a Restore object.

  4. Set either the Devices, Files, Pipes, or Tapes property to indicate a device visible on an instance of SQL Server indicated in Step 2 and maintaining the backup media. Specify all devices or files maintaining the backup set.

  5. Call the SQLVerify method of the Restore object using the SQLServer object created in Step 1 as an argument.

Applies To:

Restore Object