Archive Rearchive table
- Last UpdatedApr 24, 2025
- 1 minute read
The Rearchive table stores the table details which need to be rearchived due to data modification.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
archId |
smallint |
This field is the Archive table identifier. |
|
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. |
|
startTime |
GMTtime |
This field is the start time of the data archive. |
|
endTime |
GMTtime |
This field is the end time of the data archive. |
|
archFile |
filenameType |
This field is the name of the archived data file. |
|
verNum |
IDType |
This field is the version number of the Archive. The version number is assigned to the Archive file name (archFile), which is composed of <system ><server> <db> <table> <dd><Mmm> <YYYY>.archive_<version_>. Version number starts at 0 and increments for each rearchive occurrence for the table's data within the same time frame. |