我们可以从SQL数据库的文件快照备份中读取备份内容吗 [英] Can we read the backup content from file-snapshot backup of SQL database
问题描述
我在azure上有一个SQL数据库，我已经对同一数据库执行了文件快照备份.
I have a SQL database on azure, i have performed a file-snapshot backup of the same database.
备份完成后，我想从blob中读取文件快照备份的内容.
Once the backup is completed i would like to read the content of the file-snapshot backup from blob.
有没有办法读取相同的档案?
Is there a way to read the same for archival?
我的要求如下:
读取备份内容并将其存档，以备将来在Azure或本地SQL实例上还原.
Read the backup content and archive it for future restore on azure or on premise SQL instance.
推荐答案
Hello,
You can use Azcopy to copy any backup stored on Azure storage account and then restore it on a computer. You cannot see the
content of a backups, but you can see a list of backup available on the storage account and you can restore them to see the content they have.
You can find more information below:
https://docs.microsoft.com/zh-cn/sql/relational-databases/backup-restore/restoring -from-backups-stored-in-microsoft-azure?view = sql-server-2017
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restoring-from-backups-stored-in-microsoft-azure?view=sql-server-2017
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于我们可以从SQL数据库的文件快照备份中读取备份内容吗的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
