Reputation: 12367
On the Holy Book of SQL Server The Messiah once described how a Test/Dev environment should look like in a perfect World:
"In a perfect world, my test/QA servers get restored nightly from production. Let’s say every night at 9pm, the production full backups kick off, and they’re finished by 10pm. At 11pm, the QA box kicks off a restore job that grabs the latest full backups off the file share and restores them."
This makes sense in an on-prem scenario but what if I have to migrate to Azure SQL Database?
Because if I really want to test the Test/Dev environment need to be on Azure SQL Database too!
The questions are:
Thank you
Upvotes: 0
Views: 765
Reputation: 89386
Sure. No different from on prem.
Dev/Test can be on a lower SLO, perhaps Serverless. There is no other cost to restore a database.
Upvotes: 1