For more information, see SQL Server Backup and Restore with Microsoft Azure Blob Storage. SQL Server backups can also be written to an Azure Blob Storage, and URL format is used to specify the destination and the name of the backup file. Backups of a database can also be used to restore a copy the database to a new location.Ī disk or tape device to which SQL Server backups are written and from which they can be restored. The process of creating a backup by copying data records from a SQL Server database, or log records from its transaction log.Ī copy of data that can be used to restore and recover the data after a failure. By using SQL Server Backup to Azure Blob Storage, you can create an off-site backup in a different region than your on-premises location, to use in the event of a natural disaster affecting your on-premises location.Īdditionally, backups of a database are useful for routine administrative purposes, such as copying a database from one server to another, setting up Always On availability groups or database mirroring, and archiving.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |