techcommunity.microsoft.com
Open in
urlscan Pro
2a02:26f0:6c00:289::207e
Public Scan
Submitted URL: https://comm.microsoft.com/PoliteMail257/default.aspx?page=Gcyp6E4XDkaNT4JjIA6xvQ&ref_id=lV0dfqeODEeQp1nMY0sf3Q
Effective URL: https://techcommunity.microsoft.com/t5/azure-database-support-blog/learning-from-expertise-2-who-dropped-my-azure-sql-db/ba-p/2149276
Submission: On March 09 via api from US — Scanned from DE
Effective URL: https://techcommunity.microsoft.com/t5/azure-database-support-blog/learning-from-expertise-2-who-dropped-my-azure-sql-db/ba-p/2149276
Submission: On March 09 via api from US — Scanned from DE
Form analysis 2 forms found in the DOM
Name: form_316b1df4135ca8 — POST https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form
<form enctype="multipart/form-data" class="lia-form lia-form-inline SearchForm" action="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form" method="post" id="form_316b1df4135ca8" name="form_316b1df4135ca8">
<div class="t-invisible"><input value="blog-id/AzureDBSupport/article-id/453" name="t:ac" type="hidden"><input value="search/contributions/page" name="t:cp" type="hidden"><input
value="o58LFbH2Ilk7l0QVEkIzIQAmWE8gAhkcLtUFM9rf78T_8dhCAWxnKmC8AUkTh5GFmi1CXcHFKDq1D8FB8v7CFWT6lXT0BjUeFi6WT_GFmB55EnA36yx-Iapwmusn2MWckw98Y3Q2wOXyaTrEbTl8u_4x3CGkl-p4RANkd0Adxro_WjglxQZORHVmn9oX6EtdCESLUWKEH431ydStyY1o9EOu5JGPjMtjhlM2KaXY3mgI6OOJm9Y-Iad5119at5zwtNb4Z4IjDsEu50lJZRPfJIDdWcqG4wByuRXJVdMEeGMKmT6YFNKp5sbcO0gu8XlmnN0jpqLJIZy-vBFWC-K45B8WIqt1Jh80eaQ8cniqPc8TPRF6ZvSSFdBXFBxp_lvsnyDhpnBlFmTQAd71k3qoqivpS4CqhTzo73tHuS0PoJ1VTzvWV3tem3dtVDYceAlgLKdyuTgBsqNtZQMmgPumAxIKUnfPszbi9uVdaXLSBF0qwq-sRUCZz_LMh1UpwWGAUekHQrFjphrVgqqgl0XhFzgpt9ZWdEmpH1zGHCE97ZzOHbBBdz4vkii8tTZAf81KCJ42RoFpzVgBzcgoBYzB3MOynluXWIosiGQRL-cg4YR6E47ncIp1OFPwuKYrnscH1YwpcYfa6SogynXuiApovkmuIFLZgnZmQXPDmm2i67k5vSY8KKvk9mkhd6QMynJXb7FsWPo96_DIBsYOv_amIWkd-0kwtEl0h349SPKkVc-xiyUTjsbAbcC3GaEfK30vTILJuOX6IpcsAmVszrU6fXu2uqIo9lKZjfR2gdqNk3xigmlrziDhK_08sflqBYTyWZnsTSt6u3-44eFRc554p46oJzBFRtBiVYWDKgMg2ILeI0XINlPpqVMg6BKbzf-FXWASwGpViU5Y66swu7SlbPGw83XpH5doL41wt_vPQfuJQeIBlNR3-QbAPmCUe1o9NT_AXPhBqA4JqWol9ivAGgiM1YLkF0XHKn9iwpBAifYJXbybP1lFGZLdVKYDuW8VoAQ7MNx-S0TGMHExN651SvSLpGi6YMemBcVy6UNS_zLYzXHPV36GumP9SuiBEf77DAMNQKHyDwYrC5B6es2vALPhB3FmyvpZcztYQRCqJrVxMBFAHeRoNvKBVrdZIDV90-ghlJykj1ala8aKeRs5BtKJgw5vlr_TzAtSUg7DRD4tHdjFqf3xuV5-HPe1Fs2rT6AoNS-patBxIBGW2CldT77FVPRCmblqE0b7I5lXMRM7zq5I5BCmPb3zOSyZIHbpHCWNbjautE34pZqtF3QScw.."
name="lia-form-context" type="hidden"><input value="BlogArticlePage:blog-id/AzureDBSupport/article-id/453:searchformv32.form:" name="liaFormContentKey" type="hidden"><input
value="dzOv4c3RXyNwwkfp7lwVMGy6yiU=:H4sIAAAAAAAAALWRQUrDQBSGn4WuigiiN9DtRNRuVIQiKELVYHAtM+lrGk0ycWbSxI1H6QnES3Thzjt4ALeuXDiTRKlVMJG4CvO/8H/fm7l/gXa6D3sSqXBHlssjJXyWKJ9H0rKphzvFZMhFON7aJDJhoa/Kj/kbMyUFdLnwCI2pO0KiaIxSidsucbnAwGeEUYmkx3RIXXXoYzBYc1Al8frFtPO8+vjWgoU+dHI2D05piAqW+1d0TK2ARp7laKXI281iBYsF+KAANyDeqytuC+6ilI7pkVLTpg+D7eHr5KkFkMXpGZxUNQp1jU7L0JT/EMkbuAPQ91GOnHyUqzTOMqh2eg521VZ1zWotsfJ9icuN/wAWmxzDUdXiRKKYrZw7fyywZPLZJ2gOUVs54urLLcydP5VN/kflXxC58jtO8j6qQQQAAA=="
name="t:formdata" type="hidden"></div>
<div class="lia-inline-ajax-feedback">
<div class="AjaxFeedback" id="feedback_316b1df4135ca8"></div>
</div>
<input value="aJCfBvcsGgbXBOc5O1YS6KSBosOk5Ag_9vnCGmLDY04." name="lia-action-token" type="hidden">
<input value="form_316b1df4135ca8" id="form_UIDform_316b1df4135ca8" name="form_UID" type="hidden">
<input value="" id="form_instance_keyform_316b1df4135ca8" name="form_instance_key" type="hidden">
<span class="lia-search-input-wrapper">
<span class="lia-search-input-field">
<span class="lia-button-wrapper lia-button-wrapper-secondary lia-button-wrapper-searchForm-action"><input value="searchForm" name="submitContextX" type="hidden"><input class="lia-button lia-button-secondary lia-button-searchForm-action"
value="Search" id="submitContext_316b1df4135ca8" name="submitContext" type="submit"></span>
<input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-message" value="" id="messageSearchField_316b1df4135ca8_0" name="messageSearchField"
type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="J2PWqOMF79581vbht3neF-lhbZAWH-p21dS6u_rjThw." rel="nofollow" id="disableAutoComplete_316b1df43e0009" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-tkb-article lia-js-hidden" value="" id="messageSearchField_316b1df4135ca8_1"
name="messageSearchField_0" type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="bfBfSQHcQMDIooHGMj0GFjesIrTGZVoIj_OuZ5Ld6js." rel="nofollow" id="disableAutoComplete_316b1df4c18484" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input placeholder="Search all content" ng-non-bindable="" title="Enter a user name or rank" class="lia-form-type-text UserSearchField lia-search-input-user search-input lia-js-hidden lia-autocomplete-input"
aria-label="Enter a user name or rank" value="" id="userSearchField_316b1df4135ca8" name="userSearchField" type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a user name or rank</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="88iF65C04TuNY0b1IK_M3REgVc694-kTANzzVdotfTY." rel="nofollow" id="disableAutoComplete_316b1df4edff07" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input title="Enter a search word" class="lia-form-type-text NoteSearchField lia-search-input-note search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="noteSearchField_316b1df4135ca8_0"
name="noteSearchField" type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="wd7l-hKj5hCpdLGWlqTegDCmTSWrvqddSj2M64rOaFk." rel="nofollow" id="disableAutoComplete_316b1df519a43d" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input class="lia-as-search-action-id" name="as-search-action-id" type="hidden">
</span>
</span>
<span class="lia-cancel-search" tabindex="0">cancel</span>
</form>Name: form — POST https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form
<form enctype="multipart/form-data" class="lia-form lia-form-inline SearchForm" action="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form" method="post" id="form" name="form">
<div class="t-invisible"><input value="blog-id/AzureDBSupport/article-id/453" name="t:ac" type="hidden"><input value="search/contributions/page" name="t:cp" type="hidden"><input
value="4C8GGUIVC9qw4E26tGbKfkLLZFPAn7uFHHRyhJoOcmj_Jv00vWGxPxKe0mT8oFEYy3zEXWAHaY2azsLx1qKG5jKE_4zS6g6PeQZwHUopa2bLFJ9lN-2UQ8qN-9O6Hd2pWjalTpbVcpDnwev16dD4Sw1XtpW56p7ANjl9K8YIncGehyDGoKstVCLo8sZOxfNcuTN_pNR8r-qFQatjVZzybm2Ja2pF-rCyOBnNnq6t8pmmwc1rDkepECl7_fLwGoxp2HsN2xcmNfAW560TXOcEh0rdofwkD9UcVITkNQWbUN-NHuaT5Glh2R9xoNgh47j1cLxZG7THPhfEqYIqMGNk6g0LG5145vqkPg31qTfdz6jnov-8HTpzz6zfQtUjIeghk-3YsQxUSlcmVI-sLFr6nsYFGs1-wHOhGMPl3LGvImaDyc0fGtfp-AvPhue9T5PsQsnAKBDIisJx020pjLiLPVfn9nFx-ar2PsP_1rghs-E3rC0N6f3YE9TH2GpVCf7HdJanFJhTyy7qOapZvcHOY1olpw8Gv4tnCF1-1Bm5V7viTimKqZRVEpdKWOD6hupnrijcVSxWBUnJq-O2lQyyunLv_ps0fbJR6d-BCfX7E61sJeO2ZE-tm6SS4X5vwjCQSlUPMNivoiaKu-UZVDYZuHWNToE37FmsoZ2KB7wxrWWxZZoxtOigMJAAmDobzcdrUTzkTPJJsiACBnjcFeUV1TQxqABCLYD-mBNOnbyeiv8CgYyClCIH1mp7TmY_XV59sUz4giDM6ab5pq3BRDBb7oRDr2cE3_Bw1UYvmivYVfuZtiJorTjTauer8JYM9awPi_Ixnc5Et8uCLEVTk7ZFsWQvR30wEiCSycjH0Lj79DwMOecZqRYNzCxoCXZNSTYcinM8mp7-PeJweAG47b8JGb5ismYyw3cvBnkzBzmrLqd7XF_iF6FccFJK80n53aVyUoa3jX1Y632Fw3-kazXsEAi4rd3bMhsTEStRtiMlJLLg6VWoY7hbQre3VWdkBjiZJbjTLmok7enCmhNkaqLTHGgQ-pClzPKoygSS-yGObF-MMwn5_CXPG3l1bk2mob03o77BUoujRntZXJ0vxK2-7E0oBTl2Ic4HenOOT9nUc-b_oknFUqM9aDQssdLicpw-crpi2dhpfvMtjFH5TR7uB0ldA-aowerVxMXxZW9C8RU."
name="lia-form-context" type="hidden"><input value="BlogArticlePage:blog-id/AzureDBSupport/article-id/453:searchformv32.form:" name="liaFormContentKey" type="hidden"><input
value="dzOv4c3RXyNwwkfp7lwVMGy6yiU=:H4sIAAAAAAAAALWRQUrDQBSGn4WuigiiN9DtRNRuVIQiKELVYHAtM+lrGk0ycWbSxI1H6QnES3Thzjt4ALeuXDiTRKlVMJG4CvO/8H/fm7l/gXa6D3sSqXBHlssjJXyWKJ9H0rKphzvFZMhFON7aJDJhoa/Kj/kbMyUFdLnwCI2pO0KiaIxSidsucbnAwGeEUYmkx3RIXXXoYzBYc1Al8frFtPO8+vjWgoU+dHI2D05piAqW+1d0TK2ARp7laKXI281iBYsF+KAANyDeqytuC+6ilI7pkVLTpg+D7eHr5KkFkMXpGZxUNQp1jU7L0JT/EMkbuAPQ91GOnHyUqzTOMqh2eg521VZ1zWotsfJ9icuN/wAWmxzDUdXiRKKYrZw7fyywZPLZJ2gOUVs54urLLcydP5VN/kflXxC58jtO8j6qQQQAAA=="
name="t:formdata" type="hidden"></div>
<div class="lia-inline-ajax-feedback">
<div class="AjaxFeedback" id="feedback"></div>
</div>
<input value="xWCOh1xAtvzISL9G0lSpx6glZh2GzeqBNyNzcSK0iP0." name="lia-action-token" type="hidden">
<input value="form" id="form_UIDform" name="form_UID" type="hidden">
<input value="" id="form_instance_keyform" name="form_instance_key" type="hidden">
<span class="lia-search-input-wrapper">
<span class="lia-search-input-field">
<span class="lia-button-wrapper lia-button-wrapper-secondary lia-button-wrapper-searchForm-action"><input value="searchForm" name="submitContextX" type="hidden"><input class="lia-button lia-button-secondary lia-button-searchForm-action"
value="Search" id="submitContext" name="submitContext" type="submit"></span>
<input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-message" value="" id="messageSearchField_0" name="messageSearchField" type="text"
aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="vurXn2OFc4Mr-BJtm6PYJJKfazhJCauu_U85a9KkYPk." rel="nofollow" id="disableAutoComplete_316b1df5af531d" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-tkb-article lia-js-hidden" value="" id="messageSearchField_1"
name="messageSearchField_0" type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="vG38R_EqHTzwBo_nx1cu0ynRCA_JgRZpUci80AKGHRE." rel="nofollow" id="disableAutoComplete_316b1df5d8df2c" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input placeholder="Search all content" ng-non-bindable="" title="Enter a user name or rank" class="lia-form-type-text UserSearchField lia-search-input-user search-input lia-js-hidden lia-autocomplete-input"
aria-label="Enter a user name or rank" value="" id="userSearchField" name="userSearchField" type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a user name or rank</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="ItNO_cvlLCoT3mUHkj61r-Eqm7VhX6SQHRpat5OkmTo." rel="nofollow" id="disableAutoComplete_316b1df5fdab81" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input title="Enter a search word" class="lia-form-type-text NoteSearchField lia-search-input-note search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="noteSearchField_0" name="noteSearchField"
type="text" aria-autocomplete="both" autocomplete="off">
<div class="lia-autocomplete-container" style="display: none; position: absolute;">
<div class="lia-autocomplete-header">Enter a search word</div>
<div class="lia-autocomplete-content">
<ul></ul>
</div>
<div class="lia-autocomplete-footer">
<a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="derriGpVmJ09EVQc4ovc8_P4bw01dTl48nIrDDh6fD0." rel="nofollow" id="disableAutoComplete_316b1df623cb51" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/AzureDBSupport/article-id/453&t:cp=action/contributions/searchactions">Turn off suggestions</a>
</div>
</div>
<input class="lia-as-search-action-id" name="as-search-action-id" type="hidden">
</span>
</span>
<span class="lia-cancel-search">cancel</span>
</form>Text Content
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You may change your selection by clicking “Manage Cookies” at the bottom of the page. Privacy Statement Third-Party Cookies Accept Reject Manage cookies Skip to main content Microsoft Tech Community Home Community Hubs Community Hubs * Community Hubs Home * Products * Special Topics * Video Hub Close PRODUCTS (69) SPECIAL TOPICS (42) VIDEO HUB (843) MOST ACTIVE HUBS Microsoft Teams Excel Exchange SharePoint Windows Office 365 Security, Compliance and Identity Windows Server Microsoft Edge Insider Azure Microsoft 365 Azure Databases Fully managed intelligent database services. Autonomous Systems Create and optimise intelligence for industrial control systems. Yammer Connect and engage across your organization. MOST ACTIVE HUBS ITOps Talk Education Sector Microsoft Learn Microsoft Localization Microsoft 365 PnP Healthcare and Life Sciences Public Sector Internet of Things (IoT) Mixed Reality Enabling Remote Work Small and Medium Business Humans of IT Empowering technologists to achieve more by humanizing tech. Green Tech Raise awareness about sustainability in the tech sector MVP Award Program Find out more about the Microsoft MVP Award Program. VIDEO HUB Azure Exchange Microsoft 365 Microsoft 365 Business Microsoft 365 Enterprise Microsoft Edge Microsoft Outlook Microsoft Teams Security SharePoint Windows Browse All Community Hubs Blogs Blogs Events Events * Events Home * Microsoft Ignite * Microsoft Build * Community Events Microsoft Learn Microsoft Learn * Home * Community * Blog * Azure * Dynamics 365 * Microsoft 365 * Security, Compliance & Identity * Power Platform * Github * Teams * .NET Lounge Lounge * 802K Members * 6,186 Online * 2.2M Discussions Search Enter a search word Turn off suggestions Enter a search word Turn off suggestions Enter a user name or rank Turn off suggestions Enter a search word Turn off suggestions cancel Turn on suggestions Showing results for Show only | Search instead for Did you mean: Sign In Sign In Enter a search word Turn off suggestions Enter a search word Turn off suggestions Enter a user name or rank Turn off suggestions Enter a search word Turn off suggestions cancel Turn on suggestions Showing results for Show only | Search instead for Did you mean: * Home * Azure Data * Azure Database Support Blog * Learning from Expertise #2: Who Dropped my Azure SQL DB? * Back to Blog * Newer Article * Older Article LEARNING FROM EXPERTISE #2: WHO DROPPED MY AZURE SQL DB? * Subscribe to RSS Feed * * Mark as New * Mark as Read * * Bookmark * Subscribe * * Email to a Friend * * Printer Friendly Page * Report Inappropriate Content By Ahmed Mahmoud Published Feb 23 2021 01:05 AM 3,201 Views Skip to footer content Ahmed_S_Mahmoud Microsoft Feb 23 2021 01:05 AM LEARNING FROM EXPERTISE #2: WHO DROPPED MY AZURE SQL DB? Feb 23 2021 01:05 AM OVERVIEW: Azure SQL Database can be dropped through Azure SQL database API call using "Microsoft.Sql/servers/databases/delete" operation via Azure Portal, CLI, Powershell commands or Rest API call at Azure platform one side or at the database level another side using SQL Server Management Studio or T-SQL command: DROP DATABASE database04; In this article, we will provide a guideline on Azure solutions to secure, protect, recover, audit and monitor Azure SQL DB against unintended deletion. SOLUTION: In this section, we are listing Azure solutions to secure Azure SQL DB against unintended deletion, know who the caller for the database deletion, when this happened and how get alerted in such case. Moreover, how to recover your database. 1- Enable Azure SQL Auditing The best resort to answer the blog main question, who dropped my database? is to enable Azure SQL Auditing, enabling auditing tracks database events and write them to audit log which can be stored into Azure storage account, Log Analytics workspace or Event Hubs. Leverage the Log Analytics to retrieve and filter the Audit records, the following example is a Kusto Query to get audit data for the dropped database: let ServerName = "XXXXXXXXXX"; # Change the Server name to Azure SQL Server name AzureDiagnostics | where LogicalServerName_s =~ ServerName | where Category =~ "SQLSecurityAuditEvents" | where statement_s contains "DROP" | project TimeGenerated, event_time_t, LogicalServerName_s, database_name_s, succeeded_s, session_id_d, action_name_s,client_ip_s, session_server_principal_name_s , database_principal_name_s, statement_s, additional_information_s, application_name_s | top 1000 by TimeGenerated desc TIP: change the time range to the roughly incident time or you can add clause | where TimeGenerated >= ago(5d) Query Output:- You can find more details by expanding the audit data record:- For more examples, I would recommend review blog for colleague @FonsecaSergio: AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #3 - Query AUDIT data or Who dropped my TABLE?... Additional information regarding Azure SQL audit and Log Analytics:- Azure SQL Auditing for Azure SQL Database and Azure Synapse Analytics - Azure SQL Database | Microso... Overview of Log Analytics in Azure Monitor - Azure Monitor | Microsoft Docs Log Analytics tutorial - Azure Monitor | Microsoft Docs 2- Create Alerts You can create an alert at different resource levels from subscription down to Azure SQL resource to get notified in case a database was deleted, you will need to enable alert for activity log "Delete Azure SQL Database (Microsoft.Sql/servers/databases)" at the preferenced resource level. As shown in below example:- Choose the activity log Delete Azure SQL Database (Microsoft.Sql/servers/databases) :- Once the activity log event triggered, you will be able to find more details by open the alert data entry:- You can learn more on Azure Alerts: Setup alerts and notifications in the Azure portal - Azure SQL Database | Microsoft Docs 3- Review Activity log The Activity log is a platform log in Azure that provides insight into subscription-level events. This includes such information as when Azure SQL DB is deleted, You can view the Activity log in the Azure portal or retrieve entries with PowerShell and CLI, to review the activity log from Azure portal, hit the bell icon as shown below: You can change the time range and add operation filter: "Microsoft.SQL/servers/databases/delete" to get all the deleted SQL databases in certain period, as shown in below figure:- NOTE:- You cannot retrieve activity log entries more than 90 days in the past. In case you want to store Activity log entries for longer than 90 days you can send to Log Analytics workspace to enable the features of Azure Monitor Logs, archive to a storage account or stream to an event hub. Here is a sample Kusto script to retrieve activity log for deleted SQL DB from Log Analytics :- AzureActivity | where Resource == "XXXXXXX" # Change to the database name | where OperationName == "Delete SQL database" TIP: change the time range to the roughly incident time or you can add clause | where TimeGenerated >= ago(10d) You can find more details by expanding the Activity log entry, as shown in below figure:- Learn more on Azure Activity in Azure Activity log - Azure Monitor | Microsoft Docs 4- Enable Resource Lock In order to protect your Azure SQL Database from unintended deletion, you can enable Resource lock, it can prevent deletions on the locked resources unless the lock is explicitly removed. It is very important to note that this does not prevent T-SQL deletions of the database. More information can be found in blog: Protecting deletions of Azure SQL Resources - Microsoft Tech Community 5- Restore the deleted database Lastly and most importantly, Azure will allow you to recover the deleted database to the deletion time. By using the Azure portal, open Azure SQL server overview page, and select Deleted databases. Select a deleted database that you want to restore, and type the name for the new database that will be created with data restored from the backup, and click OK. As shown in below figure:- Reference: Restore a database from a backup - Azure SQL Database & SQL Managed Instance | Microsoft Docs I hope you find this article helpful. If you have any feedback please do not hesitate to provide it in the comment section below. Ahmed S. Mazrouh * Tags: * Azure SQL * Azure SQL DB * deleted database * drop * SQLDB 6 Likes Like You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in. * Comment Co-Authors Ahmed_S_Mahmoud Version history Last update: Feb 22 2022 04:08 AM Updated by: Ahmed_S_Mahmoud SHARE * Share to LinkedIn * Share to Facebook * Share to Twitter * Share to Email Browse Skip to primary navigation WHAT'S NEW * Surface Pro X * Surface Laptop 3 * Surface Pro 7 * Windows 10 Apps * Office apps MICROSOFT STORE * Account profile * Download Center * Microsoft Store support * Returns * Order tracking * Store locations * Buy online, pick up in store * In-store events EDUCATION * Microsoft in education * Office for students * Office for schools * Deals for students and parents * Microsoft Azure in education ENTERPRISE * Azure * AppSource * Automotive * Government * Healthcare * Manufacturing * Financial Services * Retail DEVELOPER * Microsoft Visual Studio * Window Dev Center * Developer Network * TechNet * Microsoft developer program * Channel 9 * Office Dev Center * Microsoft Garage COMPANY * Careers * About Microsoft * Company News * Privacy at Microsoft * Investors * Diversity and inclusion * Accessibility * Security * Sitemap * Contact Microsoft * Privacy * Manage cookies * Terms of use * Trademarks * Safety and eco * About our ads * © 2022 Microsoft Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.