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
Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics