(Microsoft SQL Server only) Returns device offset information about primary database log devices from the RASD log device repository.
ra_helpdeviceoffset
This command returns the device offset information about all primary database log devices recorded in the log device repository.
ra_helpdeviceoffset 1
This command returns information about the primary database log device ID 1 in the log device repository.
Device ID – the log device ID defined by the primary data server.
Database name – the name of the primary database associated with the log device.
Device name – the logical name of the log device defined by the primary data server.
Server device path – the path to a multiplexed version of the log device.
Disk device path – the path to the log device (at the standby site).
Disk device offset – the offset from which Replication Agent starts to scan the log in the log device.
Disk device status – the current status of the server device path (ACCESSIBLE, NOT_VALID, or OPEN).
The disk device path is the current value recorded in the RASD. Replication Agent uses the disk device path recorded in the RASD to locate each log device.
For each log device recorded in the RASD, you can set or change the disk device path using ra_devicepath, and set or change the device offset using ra_deviceoffset.
If you do not specify a disk device path using ra_devicepath, the value recorded for the disk device path is DEFAULT, and Replication Agent uses the value recorded for the server device path to find the log device.
The disk device status is updated by the Log Reader component each time you invoke ra_helpdeviceoffset.
If ra_helpdeviceoffset is invoked with no option, it returns information for all log devices recorded in the RASD log device repository.
If ra_helpdeviceoffset is invoked with the device option, it returns information only for the specified log device.
The ra_helpdeviceoffset command is valid when the Replication Agent instance is in Admin, Replicating, or Replication Down state.