I am proposing an Azure environment with the following:
- VM SQL Server for core relational data
- Table Storage for bulk data
I want to mirror the SQL Server database to another server so that
- Reports can be run on this server so to minimize data load on the primary database, and
- It can serve as a failover server in case the primary server goes down.
In order to achieve these 2 objectives I would also need to mirror the Azure Table Storage too. I can't seem to find any information on this. Is this even possible?