sys.dm_continuous_copy_status (Azure SQL Database and Azure SQL Managed Instance)
Applies to: 
Azure SQL Database
Azure SQL Managed Instance
This view has been superseded by sys.dm_geo_replication_link_status and is preserved for backwards compatibility.
| Column Name | Data Type | Description |
|---|---|---|
| copy_guid | uniqueidentifier | Unique ID of the replica database. |
| partner_server | sysname | Name of the linked logical server or linked managed instance. |
| partner_database | sysname | Name of the linked database on the linked logical server or linked managed instance. |
| last_replication | datetimeoffset | The timestamp of the last applied replicated transaction. |
| replication_lag_sec | int | Time difference in seconds between the current time and the timestamp of the last successfully committed transaction on the primary database that has not been acknowledged by the active secondary database. |
| replication_state | tinyint | The state of continuous-copy replication for this database. The following are the possible values and their descriptions. 1: Seeding. The replication target is being seeded and is in a transactionally inconsistent state. Until seeding completes, you cannot connect to the active secondary database. 2: Catching up. The active secondary database is currently catching up to the primary database and is in a transactionally consistent state. 3: Re-seeding. The active secondary database is being automatically re-seeded because of an unrecoverable replication failure. 4: Suspended. This is not an active continuous-copy relationship. This state usually indicates that the bandwidth available for the interlink is insufficient for the level of transaction activity on the primary database. However, the continuous-copy relationship is still intact. |
| replication_state_desc | nvarchar(256) | Description of replication_state, one of: SEEDING CATCH_UP RE_SEEDING SUSPENDED |
| is_rpo_limit_reached | bit | This is always set to 0 |
| is_target_role | bit | 0 = Source of copy relationship 1 = Target of copy relationship |
| is_interlink_connected | bit | 1 = Interlink is connected. 0 = Interlink is disconnected. |
Permissions
To retrieve data, requires membership in the db_owner database role. The dbo user, members of the dbmanager database role, and the sa login can all query this view as well.
Remarks
The sys.dm_continuous_copy_status view is created in the resource database and is visible in all databases, including the logical master. However, querying this view in the logical master returns an empty set.
If a geo-replication link, also known as a continuous-copy relationship, is terminated on a database, the row for that database in the sys.dm_continuous_copy_status view disappears.
Like the sys.dm_database_copies view, sys.dm_continuous_copy_status reflects the state of the continuous copy relationship in which the database is either a primary or active secondary database. Unlike sys.dm_database_copies, sys.dm_continuous_copy_status contains several columns that provide details about operations and performance. These columns include last_replication, and replication_lag_sec..
Next steps
Learn more about related concepts in the following articles: