Explanation The default retention period for a database created using the DTU-based purchasing model depends on the service tier: * Basic service tier is 1 week. * Standard service tier is 5 weeks. * Premium service tier is 5 weeks. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention