Skip to main content

Limitations

Every product has limitations. Below is a list of Microsoft SQL Server limitations:

License​

  • The standard license is applied.

Configurations​

  • Single node (no High Availability)
  • Always On (2 nodes, asynchronous commit mode, High Availability)

Always On-specific limitations​

  • Refer to the Microsoft standard license for a complete list of limitations.
  • Only asynchronous commit mode is currently supported.
  • The ccxdb is currently the only supported Always On enabled database.
  • Scaling is not supported as the standard license does not permit more than two nodes.

User-created databases (not Always On) are not transferred to the replica​

  • In the Always On configuration, only the ccxdb is replicated.
  • Data loss may occur for other user-created databases, as they are not transferred to the replica during the add node process. Therefore, they may be lost if a failover, automatic repair, or any other life-cycle management event occurs.