Archive ScheduleAuditTrail table

archId

IDType

This field is the unique Archive identifier.

archEnable

boolType

This field indicates whether to enable or disable archiving.

svrName

sysnameType

This field is the name of the computer running SQL Server.

dbName

sysnameType

This field is the name of the database to Archive.

tableName

sysnameType

This field is the name of the table to archive.

archDevice

devnameType

This field is the name of the destination Archive device.

archCutoff

cutoffType

This field specifies the last date of records to be archived. The format is YY:MM:DD.

delCutoff

cutoffType

This field specifies the last date of records to be deleted. The format is YY:MM:DD.

lastModUser

nvarchar(96)

This field indicates the user who modified the Archive schedule.

lastModTime

datetime

This field indicates the time of modification.