(SQL) Tip of the Day: Geo Replication with TDE

Today’s Tip…

Just a current issue we have been facing that you may run into.

If you are running your SQL Azure database with Geo Replication and you have TDE enabled on your database currently you will not be able to scale your DB to other editions. The error you will see when you attempt to do this says:

Database scale operation from P1 Premium to P2 Premium failed for <Database Name>. ErrorCode: BadRequest ErrorMessage: The operation cannot be performed since the database '<Database Name>' is in a continuous copy relation.

We soon will be providing a better error message in the portal for this issue.