SQL Server enables you to back up your data to Azure Blob Storage, which is a fairly cheap storage service, frequently used for Azure cold storage. Backup targets are usually disks or tapes, since such formats are still the preferred and most reliable “offline” methods for storing data.Ī newer approach in Azure database backup is to back up your database directly to a cloud storage service. It's a straightforward process that hasn't changed much since SQL Server was released. Azure Backup: for SQL Hosted Databases Step by Stepīacking up an SQL server is usually done with SQL Server Management Studio (SSMS). In this post we'll show you how to do that using Azure storage as the target repository. Hopefully, you'll never have to restore your backups, but in case that ever happens, you should always backup your data and verify it on a regular basis. There are a number of different solutions for Azure backup SQL databases users can turn to. Having Azure backup plans can be a big help here. Another concern-one which probably won't be resolved anytime soon-is the reliability of the infrastructure you're using to host your database. Databases are more stable and reliable than they used to be, but there's still a possibility that you can lose data due to a bug in the database engine.
0 Comments
Leave a Reply. |