Share via

Azure sql databases

Paul Murphy 21 Reputation points
2021-12-14T01:13:04.79+00:00

I have 4 sql databases. 2 Production, 2 Development/Test. To save time updating the appropriate data between the Production and Development databases, if I delete the 2 Development ones and then create new copies of the Production ones as Development ones, will this impact on our costs. Thinking of doing this on a routine basis. Thanks Paul

Azure SQL Database
0 comments

Answer accepted by question author

Alan Kinane 17,361 Reputation points MVP Volunteer Moderator
2021-12-14T09:38:39.497+00:00

it would depend on a lot of factors. If they are provisioned single Azure SQL databases then they are billed per hour. If they are serverless then it's per second. You would see cost savings if they were deleted for a time here.

If you are using an elastic pool for all 4 databases then you won't see any cost saving.

https://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.