Forum Widgets
Latest Discussions
Read Replica for DR with Failback
Hi, I have been experimenting with Azure MySQL Flexible Server Read Replica as a DR scenario and it works really well. The manual failover process is successful. However, I am now trying to configure a failback scenario whereby I reconfigure the now standalone MySQL Read Replica server in the DR region to enable geo-redundant backup storage and then I try to initiate a Universal Geo Restore of this server to a different Azure region. The Geo Restore operation fails with the following error : "The resource operation completed with terminal provisioning state 'Failed'" The MySQL Flexible servers (source and Read Replica) are configured for Private Networking (VNet Integration not Private Endpoint) and the Virtual Networks are peered. They both use the same Private DNS Zone which is linked to both VNets as well. It feels like this *should* work but I can't figure out why it is failing. If anyone has any insight it would be appreciated. Regards, Paul Lynch
Keep Previous RowCounts in a table - T-SQL
I am currently able to get the rowcount for each table in a schema. On this particular database history is not stored, so each day when I run this script, the counts are likely to differ. What I need to do is somehow keep a record of what the counts for each table were on previous dates. Is there a way I can do this using T-SQL - I can't seem to figure out how to approach this. Also CDC is disabled - so I am limited to having to script a solution using T-SQL. The table I get daily simply lists schema, tablename and rowcount - rowcount is realtime. I would like to keep previous counts associated with a date so result will produce a table with - schema, tablename RowCount_19May, RowCount_18May, RowCount_17May, ... , RowCount_1May. Even if i need to start today and the append each new days counts as the days go by is expected and I'd be good with that.
ETL from SQL Server into Azure SQL managed instance
Normally I use linked servers to connect my datawarehouse database to other databases to do my ETL using stored procedures that were scheduled. But now, we are moving to Azure managed SQL server. Is there an easy way to do things like run stored procedures that will pick data from source and move into destination SQL data warehouse database? If linked servers is not available then that makes it kind of hard to code SP's that pick from source. I started looking into Azure pipes, but was wondering if there is an easier way that is more compatible with the way I have been doing it in the past....
