共用方式為

PercentComplete Event

  • 發行項

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The PercentComplete event occurs when a backup, restore, or replication operation reaches a completion unit.

語法

Private Sub
object
_PercentComplete(
Message as String
, 
Percent as Long
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Message
    String that contains descriptive message text.
  • Percent
    Long integer representation of a percentage value. The value is the percent of processing complete scaled by 100. For example, a process seven percent complete reports the value 7.

Prototype (C/C++)

HRESULT PercentComplete(SQLDMO_LPCSTR Message, long Percent);

備註

With SQL Distributed Management Objects (SQL-DMO), use the SQLBackup, SQLRestore, and SQLVerify methods to start a backup or restore operation.

By default, SQL-DMO raises the PercentComplete event as each tenth of a backup or restore operation completes (when the percent of the operation completed is 10, 20, 30, and so on). Use the PercentCompleteNotification property of the Backup and Restore objects to change default behavior.

For the Replication object, the PercentComplete event is reserved for future use.

Applies To:

Backup Object

Restore Object

Replication Object