Learn SQL #2 : How is data stored in a database?
Inside a database, data is stored into …
Imagine how cool would it be: you are on vacation on a beach when you receive a panicked email from your client telling you he has lost all his data. You take your smartphone, log in to sqlbak.com, press “Restore” next to the last backup, and in a few minutes tell the client that his database was restored. This is as close to James Bond as a database administrator could ever get!
In spite of \having been through a data compression process, the compressed backup actually has a few advantages over regular backups.
Unfortunately, there is no standard or specific feature to backup a table in SQL Server, but there are workarounds.
This can be a very common request from clients, as they might want to backup specific tables from their databases, and as there is no feature in SQL Server that offers this functionality out of the box, then we need to create our own way.
Having the possibility to backup your SQL Server databases to Windows’s cloud platform is very convenient, easy, and takes a great weight off your organization’s shoulders but there are a few things that improve this process.
Just by adopting a few good practices in your work with Azure you can improve the entire flow of backing up and restoring your databases.