TapeLoadWaitTime Property

  • Article

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 TapeLoadWaitTime property specifies the number of minutes a Microsoft SQL Server backup or restore operation waits when trying to write to or read from an indicated tape medium.

Syntax

object
.TapeLoadWaitTime [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.
  • value
    A long integer that specifies a number of minutes as described in Settings.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTapeLoadWaitTime(LPLONG pRetVal)
HRESULT SetTapeLoadWaitTime(long NewValue)

Settings

Value Description

-1

Default. A backup or restore operation does not time out.

0

A backup or restore operation attempts to access the tape device exactly one time.

Any positive integer

The number of minutes during which the backup or restore operation attempts to access the tape device.

Applies To:

Registry Object