Database elastic pool backups

Question

_{Tuesday, October 10, 2017 11:05 AM}

Does databases inside elastic pool has the built-in backups ( both point in time and long term retention ) ? If yes, does the backup storage is same like single sql database as stated in document ( SQL Database provides up to 200% of your maximum provisioned database storage as backup storage at no additional cost ) ?

All replies (2)

_{Tuesday, October 10, 2017 11:41 AM ✅Answered | 2 votes}

Hello,

Point-in-time restores and long term backups are both available on elastic pools. Any database on a pool can be configured with retention policy (long-term backup).

Point-in-time restore uses automatic database backups to recover a database in a pool to a specific point in time.

Source: /en-us/azure/sql-database/sql-database-elastic-pool

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

_{Tuesday, October 10, 2017 3:50 PM}

Yes, automatic backup are available in elastic pool using point in time restore.

Please Mark as Answer if my post works for you or Vote as Helpful if it helps you. Kapil Singh