MssqlDatabase
SQL Server database.
Implements: HierarchyObject, CdmHierarchyObject, HierarchySnappable, CdmHierarchySnappableNew, MssqlTopLevelDescendantType, PhysicalHostDescendantType, WindowsClusterDescendantType, MssqlAvailabilityGroupDescendantType, MssqlAvailabilityGroupLogicalChildType, MssqlInstanceDescendantType, MssqlInstanceLogicalChildType, MssqlHostDescendantType
Fields
| Field | Type | Description |
|---|---|---|
| allOrgs | [Org!]! | Organizations to which this hierarchy object belongs. |
| allTags | [AssignedRscTag!]! | RSC tags to which this hierarchy object is assigned. |
| authorizedOperations | [Operation!]! | The authorized operations on the object. |
| cdmGroupedSnapshots | CdmGroupedSnapshotConnection! | List of snapshots taken for a Rubrik CDM workload grouped by attributes. |
| cdmId | String! | CDM ID of the SQL Server database. |
| cdmLink | String! | A link to view the workload on the CDM cluster. For dev use only. |
| cdmNewestSnapshot | CdmWorkloadSnapshot | The newest snapshot taken for a CDM workload. |
| cdmOldestSnapshot | CdmWorkloadSnapshot | The oldest snapshot taken for a CDM workload. |
| cdmOnDemandSnapshotCount | Int! | The count of on demand snapshots for a SQL Server database. |
| cdmPendingObjectPauseAssignment | PendingObjectPauseAssignmentStatus | Object pause pending assignment details for CDM objects. |
| cdmSnapshots | CdmWorkloadSnapshotConnection! | The list of snapshots taken for a SQL Server database. |
| cluster | Cluster! | Rubrik cluster where this object originated. |
| configuredSlaDomain | SlaDomain! | SLA Domain configured for the hierarchy object. |
| copyOnly | Boolean! | Specifies if copy-only backups are enabled. When false, database backups are full backups. |
| crossAccountReplicatedObjectInfos | [CrossAccountReplicatedObjectInfo!] | Cross-account objects either replicated by this object or related to this object by replication. |
| dagId | UUID! | ID of the associated SQL Server distributed availability group object. |
| effectiveRetentionSlaDomain | SlaDomain | Effective retention of the SLA Domain of the hierarchy object. |
| effectiveSlaDomain | SlaDomain! | Effective SLA Domain of the hierarchy object. |
| effectiveSlaSourceObject | PathNode | Path node of the effective SLA Domain source. |
| hasLogConfigFromSla | Boolean! | Boolean flag indicating if the database derives log backup configurations from SLA. |
| hasPermissions | Boolean! | Specifies whether the the Rubrik Backup Service has permission to back up a SQL Server database. |
| hostLogRetention | Long! | Interval, in seconds, between the deletion of archived log files whose 'nextTime' field specifies a time longer than this interval. To specify an interval, enter a positive integer. To immediately delete archived log files regardless of age, specify an interval of -1. To preserve all archived log files, specify an interval of -2. |
| id | UUID! | ID of the hierarchy object. |
| isInAvailabilityGroup | Boolean! | Specifies if the SQL Server database is in an availability group. |
| isLogShippingSecondary | Boolean! | Specifies if the SQL Server database is a log shipping secondary. |
| isMount | Boolean! | Specifies if the SQL Server database is a live mount. |
| isOnline | Boolean! | Specifies if the SQL Server database is online. |
| isRelic | Boolean! | Specifies if the SQL Server database is a relic. |
| latestUserNote | LatestUserNote | Latest user note information. |
| liveMounts | MssqlDatabaseLiveMountConnection! | List of live mounts for a SQL Server database. |
| logBackupFrequencyInSeconds | Float! | Number of seconds between two log backups. When the value is set to 0, log backups are not enabled. When the value is set to -1, the default log backup frequency of the Rubrik cluster is used. When the value is set to -2, the log backup frequency is derived from the SLA Domain. |
| logBackupRetentionInHours | Int! | Number of hours to retain a log backup. When the value is set to -1, the Rubrik cluster retains the log backup until the database snapshots that precede the log backup have expired. When the value is set to -2, the default log backup retention of the Rubrik cluster is used. When the value is set to -3, the log backup retention is derived from the SLA Domain. |
| logicalPath | [PathNode!]! | Sequential list of the logical ancestors of this object. |
| missedSnapshotConnection | MissedSnapshotCommonConnection | The list of missed snapshots for this workload. |
| missedSnapshotGroupByConnection | MissedSnapshotGroupByConnection | The list of missed snapshots for this workload. |
| name | String! | Name of the hierarchy object. |
| newestArchivedSnapshot | CdmSnapshot | The newest snapshot archived to AWS. |
| newestIndexedSnapshot | CdmSnapshot | The most recent indexed snapshot of this workload. |
| newestReplicatedSnapshot | CdmSnapshot | The newest snapshot replicated to a cluster. |
| newestSnapshot | CdmSnapshot | The most recent snapshot of this workload. |
| numWorkloadDescendants | Int! | Number of descendant workloads of this object. |
| objectPauseStatus | ObjectPauseStatus | Pause status of the hierarchy object. |
| objectType | HierarchyObjectTypeEnum! | Type of this object. |
| oldestSnapshot | CdmSnapshot | The oldest snapshot of this workload. |
| onDemandSnapshotCount | Int! | The number of on-demand snapshots. |
| pendingObjectDeletionStatus | PendingSnapshotsOfObjectDeletion | Mapping from object ID to pending object deletion status. |
| pendingSla | SlaDomain | SLA Domain assignment of the object during the process of being communicated over to Rubrik CDM. |
| physicalPath | [PathNode!]! | Sequential list of the physical ancestors of this object. |
| postBackupScript | String! | Information about the script run after a backup. |
| preBackupScript | String! | Information about the script run before a backup. |
| primaryClusterLocation | DataLocation! | The source cluster of this object. Returned as a data location because there is no guarantee that Rubrik has knowledge about the source cluster. |
| recoveryModel | String! | Specifies if the recovery model is simple, full, or bulk-logged. |
| replicas | [CdmMssqlDbReplica!]! | List of the replicas available for the SQL Server database. |
| replicatedObjectCount | Int! | The number of objects either replicated by this object or related to this object by replication. |
| replicatedObjects | [CdmHierarchyObject!]! | Objects either replicated by this object or related to this object by replication. |
| securityMetadata | SecurityMetadata | Security posture metadata. |
| slaAssignment | SlaAssignmentTypeEnum! | SLA Domain assignment type for this object. |
| slaPauseStatus | Boolean! | Pause status of the effective SLA Domain of the hierarchy object. |
| snapshotConnection | CdmSnapshotConnection | The list of snapshots taken for this workload. |
| snapshotDistribution | SnapshotDistribution! | Distribution of the snapshots of the hierarchy object. |
| snapshotGroupByConnection | CdmSnapshotGroupByConnection | GroupBy connection for the snapshots of this workload. |
| snapshotGroupBySummary | CdmSnapshotGroupBySummaryConnection | GroupBy connection for the snapshots of this workload. |
| unprotectableReasons | [String!]! | List of reasons that a SQL Server database cannot be protected. |
| version | String | The Microsoft SQL Server version. |
Field Arguments
| Field | Argument | Type | Description |
|---|---|---|---|
| cdmGroupedSnapshots | first | Int | Returns the first n elements from the list. |
| cdmGroupedSnapshots | after | String | Returns the elements in the list that occur after the specified cursor. |
| cdmGroupedSnapshots | sortOrder | SortOrder | Sorts the order of results. |
| cdmGroupedSnapshots | CdmSnapshotFilter | [CdmSnapshotFilter!] | Filter CDM snapshots. |
| cdmGroupedSnapshots | sortBy | CdmSnapshotSortByEnum | Sorts snapshots by field. |
| cdmGroupedSnapshots | groupBy (required) | CdmSnapshotGroupByEnum! | Groups snapshots by field. |
| cdmGroupedSnapshots | timezoneOffset | Float | Offset based on the customer timezone. |
| cdmGroupedSnapshots | timezone | Timezone | Time zone identifier string. For example, 'America/Los_Angeles' is used for the U.S. Pacific Time zone. |
| cdmSnapshots | first | Int | Returns the first n elements from the list. |
| cdmSnapshots | after | String | Returns the elements in the list that occur after the specified cursor. |
| cdmSnapshots | sortOrder | SortOrder | Sorts the order of results. |
| cdmSnapshots | CdmSnapshotFilter | [CdmSnapshotFilter!] | Filter CDM snapshots. |
| cdmSnapshots | sortBy | CdmSnapshotSortByEnum | Sorts snapshots by field. |
| liveMounts | first | Int | Returns the first n elements from the list. |
| liveMounts | after | String | Returns the elements in the list that occur after the specified cursor. |
| liveMounts | sortBy | MssqlDatabaseLiveMountSortByInput | Sort by argument for Mssql database live mounts. |
| liveMounts | filters | [MssqlDatabaseLiveMountFilterInput!] | Filters for Mssql database live mounts. |
| missedSnapshotConnection | first | Int | Returns the first n elements from the list. |
| missedSnapshotConnection | after | String | Returns the elements in the list that occur after the specified cursor. |
| missedSnapshotConnection | filter | MissedSnapshotFilterInput | Filter missed snapshots by date. |
| missedSnapshotGroupByConnection | first | Int | Returns the first n elements from the list. |
| missedSnapshotGroupByConnection | after | String | Returns the elements in the list that occur after the specified cursor. |
| missedSnapshotGroupByConnection | last | Int | Returns the last n elements from the list. |
| missedSnapshotGroupByConnection | before | String | Returns the elements in the list that occur before the specified cursor. |
| missedSnapshotGroupByConnection | filter | MissedSnapshotFilterInput | Filter missed snapshots by date. |
| missedSnapshotGroupByConnection | groupBy (required) | MissedSnapshotGroupByTime! | Group snapshots by field. |
| missedSnapshotGroupByConnection | timezoneOffset | Float | Offset based on the customer timezone. |
| missedSnapshotGroupByConnection | timezone | Timezone | Time zone identifier string. For example, 'America/Los_Angeles' is used for the U.S. Pacific Time zone. |
| newestSnapshot | beforeTime | DateTime | Specifies the time at which or before the snapshot was taken. |
| numWorkloadDescendants | first | Int | Returns the first n elements from the list. |
| numWorkloadDescendants | after | String | Returns the elements in the list that occur after the specified cursor. |
| numWorkloadDescendants | last | Int | Returns the last n elements from the list. |
| numWorkloadDescendants | before | String | Returns the elements in the list that occur before the specified cursor. |
| numWorkloadDescendants | objectTypes | [ManagedObjectType!] | Types of objects to limit the results. If absent, all object types are returned. |
| snapshotConnection | first | Int | Returns the first n elements from the list. |
| snapshotConnection | after | String | Returns the elements in the list that occur after the specified cursor. |
| snapshotConnection | last | Int | Returns the last n elements from the list. |
| snapshotConnection | before | String | Returns the elements in the list that occur before the specified cursor. |
| snapshotConnection | filter | CdmSnapshotFilterInput | Filter snapshot connection. |
| snapshotConnection | sortBy | CdmSnapshotSortByEnum | Sorts snapshots by field. |
| snapshotConnection | sortOrder | SortOrder | Sorts the order of results. |
| snapshotGroupByConnection | first | Int | Returns the first n elements from the list. |
| snapshotGroupByConnection | after | String | Returns the elements in the list that occur after the specified cursor. |
| snapshotGroupByConnection | last | Int | Returns the last n elements from the list. |
| snapshotGroupByConnection | before | String | Returns the elements in the list that occur before the specified cursor. |
| snapshotGroupByConnection | timezoneOffset | Float | Offset based on the customer timezone. |
| snapshotGroupByConnection | filter | CdmSnapshotFilterInput | Filter snapshot connection. |
| snapshotGroupByConnection | groupBy (required) | CdmSnapshotGroupByEnum! | Groups snapshots by field. |
| snapshotGroupByConnection | timezone | Timezone | Time zone identifier string. For example, 'America/Los_Angeles' is used for the U.S. Pacific Time zone. |
| snapshotGroupBySummary | first | Int | Returns the first n elements from the list. |
| snapshotGroupBySummary | after | String | Returns the elements in the list that occur after the specified cursor. |
| snapshotGroupBySummary | last | Int | Returns the last n elements from the list. |
| snapshotGroupBySummary | before | String | Returns the elements in the list that occur before the specified cursor. |
| snapshotGroupBySummary | timezoneOffset | Float | Offset based on the customer timezone. |
| snapshotGroupBySummary | timezone | Timezone | Time zone identifier string. For example, 'America/Los_Angeles' is used for the U.S. Pacific Time zone. |
| snapshotGroupBySummary | filter | CdmSnapshotFilterInput | Filter snapshot connection. |
| snapshotGroupBySummary | groupBy (required) | CdmSnapshotGroupByEnum! | Groups snapshots by field. |
Used By
Queries
- query: mssqlDatabase
- query: mssqlDatabases (via connection)
Referenced by