sp_fallback_upd_dev_drive (version 6.5)

Creates cross references to the drive letters used by the primary and fallback support servers so both servers refer to the same physical drive.

Syntax

sp_fallback_upd_dev_drive {'PrimarySvrName', 'PrimaryDrive', 'FallbackDrive'}

where

PrimarySvrName

Specifies the name of the primary server that contains inactive enrolled databases.

PrimaryDrive

Specifies the drive letter found in the phyname column of the sysdevices system table. This parameter consists of one character and a colon (:) and indicates the physical drive on the primary server for enrolled devices.

FallbackDrive

Specifies the drive letter to be used by the fallback support server. This parameter consists of one character and a colon (:).

Remarks

This procedure must be executed on the fallback support server by using a direct connection to the fallback support server, or by using a remote stored procedure call to the fallback support server while connected to the primary server.

Permission

Only the system administrator can execute this procedure on the local primary server.

Tables Used

master.dbo.spt_fallback_usg

See Also