What are the costs of running the following operation in Azure?
drop database MyDB;
create database MyDB as copy of MyDB_Clean;
The scope of the above operation is to restore an existing database to its clean version to improve web site performance.
It will run once every day via an Azure web job and would like to assess if this would be feasible in terms of costs.
MyDB_Clean
used space = 35 MB, allocated space 48 MB, using Tiers S0/S1/S2
Just the cost for the two databases, and if they fit in a single Elastic Pool, there would be no additional cost. See the Pricing Page for the different pricing models.