Azure SQL server database read only copy

MrFlinstone 476 Reputation points
2022-07-03T23:09:00.027+00:00

I have got an Azure SQL server database configured with the specific DTU based on my requirement. I would like to know if it is possible to have a read only database copy ? What I do today is create a database point in time snap and use this for reporting, I would like to have a near real time copy of the database. What is the most cost effectively way to achieve this ?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,786 Reputation points MVP
    2022-07-03T23:41:14.743+00:00

    Business critical service tier provides one free-of-charge readable replica of the database that can be used to run read-only queries such as reports and analytics. Learn more about Business Critical tier here. Azure SQL DTU premium tiers have also the same feature of free readable replicas. You can enable this feature using the portal:

    217123-image.png

    You can make changes to reports on the connection string with "ApplicationIntent=ReadOnly" parameter to make them connect to the read-only replicas.

    If you are not able to pay for premiun tiers to get free access to a read replica, you can create a replica using Azure SQL Data Sync but you will have to pay for the replica database.