I'm looking for some guidance on restoring a SQL database backup, but the challenge is that we don't have a local server environment. There's a cloud-based application running SQL in the background, and one of our users messed up a record during data entry. They wanted to fix it, but it ended up worse. Now, the cloud provider has created a backup file and certificate, and they recommend setting up an SQL environment to restore it. Unfortunately, it seems they expect us to have a DBA on hand.
The provider mentioned needing SQL 2019 or newer, and they specified that SQL Express won't work for this. I'm considering spinning something up in Azure since we have credits available as a nonprofit, but I want to know what to expect in terms of time and complexity before diving in.
Alternatively, I believe I can install SQL on my Windows 11 Pro machine just for this restoration, and it shouldn't affect any user limits. Is that a safe route? Given these options, how would you approach this situation? I hope to spend no more than about 7 business hours on this since having the provider do the restoration will cost that much. I also need to figure out how to actually restore the record and possibly export the data. Any help would be appreciated!
2 Answers
Consider restoring the backup to a different database within the same instance if you're able to get access. That way, you won’t disrupt your live environment while you test the recovery.
You should first check where the SQL environment for your cloud app is hosted. Ideally, you want to spin up a database in that environment to retrieve the data. If you’re paying for hosting, they might be able to assist you without additional costs, just explain the situation to them.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures