Simple recovery model

[LowerKees]

Is there a way to create a Sql Database with a simple recovery model? I've noticed that Sql Data Warehouse automatically creates this setting, but I haven't yet seen where I can configure this for Sql Database during provisioning.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 3da2d20f-0457-b8af-2f72-84741e8cb81b
• Version Independent ID: 3bcd4ccd-9b70-65d0-a720-57fd9a566767
• Content: Azure portal: Create a single database - Azure SQL Database
• Content Source: articles/sql-database/sql-database-single-database-get-started.md
• Service: sql-database
• Sub-service: single-database
• GitHub Login: @sachinpMSFT
• Microsoft Alias: ninarn

[SadiqhAhmed-MSFT]

@LowerKees Thanks for the comment! We will investigate on this issue and get back to you soon.

[angoyal-msft]

@LowerKees No we cannot create SQL database with "SIMPLE" recovery model. It is always created with "FULL" recovery Model. As in simple recovery model transaction log backups are not supported. Also, Point-in-time and page restore are not supported, only the restoration of the secondary read-only file is supported. While for SQL databases all the backups are required so that data can be restored if there is any failure or disaster.

The Recovery Model is set when the master database is created and cannot be modified because the ‘master’ database is read only for anyone but Microsoft. Furthermore, keep in mind that SQL Databases are continuously being replicated. Windows Azure keeps at least 3 copies of your SQL Database at all times.

You can refer this blog for more details.

Hope it helps.

[angoyal-msft]

@LowerKees I hope your concern has been resolved.
We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

[LowerKees]

This helped very much. Thanks you for the info! Kind Regards, Martijn Op wo 22 mei 2019 07:05 schreef angoyal-msft <notifications@github.com>:

…

@LowerKees <https://github.com/LowerKees> I hope your concern has been resolved. We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#31467?email_source=notifications&email_token=AIATSA6BLPN5XF2U6DTGWYDPWTIAZA5CNFSM4HNTMLXKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODV55AFY#issuecomment-494653463>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AIATSAZ65QGMFFEFS6NFJHTPWTIAZANCNFSM4HNTMLXA> .