Edit

Stretch Database - sys.dm_db_rda_schema_update_status

  • Article

Applies to: SQL Server 2016 (13.x) and later versions

Contains one row for each schema update task for the remote data archive of each Stretch-enabled table in the current database. Tasks are identified by their task ids.

Important

Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

sys.dm_db_rda_schema_update_status is scoped to the current database context. Make sure you are in the database context of the Stretch-enabled table for which you want to see schema update status.

Column name Data type Description
table_id int The ID of the local Stretch-enabled table whose remote data archive schema is being updated.
database_id int The ID of the database that contains the local Stretch-enabled table.
task_id bigint The ID of the remote data archive schema update task.
task_type int The type of the remote data archive schema update task.
task_type_desc nvarchar The description of the type of the remote data archive schema update task.
task_state int The state of the remote data archive schema update task.
task_state_des nvarchar The description of the state of the remote data archive schema update task.
start_time_utc datetime The UTC time at which the remote data archive schema update started.
end_time_utc datetime The UTC time at which the remote data archive schema update finished.
error_number int If the remote data archive schema update fails, the error number of the error that occurred; otherwise, null.
error_severity int If the remote data archive schema update fails, the severity of the error that occurred; otherwise, null.
error_state int If the remote data archive schema update fails, the state of the error that occurred; otherwise, null. The error_state indicates the condition or location where the error occurred.

See also