How can I simulate SQL Server interruption ?
Hi Expert,
For testing purpose i would like to simulate an interruption of my SQL Azure instances (this is not a VM).
Is there any way to set my SQL Server Azure as 'Inactive' so that my code will try to reach another SQL Server Azure on another datacenter for instance ?
If we cannot set as 'Inactive' could you share with me how you would do it ?
Regards,
Terry
September 1st, 2015 8:13am
You could simulate that by blocking access to your database by removing the allowed ip addresses (including the Azure services itself) inside the SQL Server Firewall settings.
See here for more info: https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
-
Marked as answer by
terry Caps
18 hours 36 minutes ago
September 1st, 2015 8:22am
You could simulate that by blocking access to your database by removing the allowed ip addresses (including the Azure services itself) inside the SQL Server Firewall settings.
See here for more info: https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
-
Marked as answer by
terry Caps
18 hours 26 minutes ago
September 1st, 2015 8:25am
Hi,
Simple suggestion:
You could simulate it by blocking access to your Azure SQL database(s) via the
firewall settings.
For example, you could write some tests scripts that turn the firewall on/off and you could check the behaviour of your app(s) while this happens.
Hope this helps!
Cheers,
Carlos
September 1st, 2015 8:31am
Thanks a lot Blue Basher I remember to get failed connection with my SQL Azure DB because of Firewall. I completely forget this method :)
September 1st, 2015 8:48am
Thanks Carlos also for your help. As I replied previously to Blue I completely forget to use Firewall method :)
Regards,
terry
September 1st, 2015 8:49am
You could simulate that by blocking access to your database by removing the allowed ip addresses (including the Azure services itself) inside the SQL Server Firewall settings.
See here for more info: https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
-
Marked as answer by
terry Caps
Tuesday, September 01, 2015 12:44 PM
September 1st, 2015 12:22pm
You could simulate that by blocking access to your database by removing the allowed ip addresses (including the Azure services itself) inside the SQL Server Firewall settings.
See here for more info: https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
-
Marked as answer by
terry Caps
Tuesday, September 01, 2015 12:44 PM
September 1st, 2015 12:22pm
You could simulate that by blocking access to your database by removing the allowed ip addresses (including the Azure services itself) inside the SQL Server Firewall settings.
See here for more info: https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/
-
Marked as answer by
terry Caps
Tuesday, September 01, 2015 12:44 PM
September 1st, 2015 12:22pm