如何检查 SQL Azure bacpac 未损坏
我刚刚在 SQL Azure bacpac 备份损坏。在恢复备份时，我使用的恢复机制都没有报告任何错误，而且架构和数据似乎都在那里，但考虑到备份肯定有问题。
我正在使用 Redgate 的 SQL Azure 备份，但是据我所知所做的就是使用创建为的副本，检查直到完成，然后使用 bacpac 导出 Azure 功能进行备份。
有没有办法确认 SQL Azure bacpac 备份没有损坏？
有关备份症状的更多信息：
- 通过 DAC 框架客户端工具 或 Azure 管理门户不报告任何错误
- 快速查看表列表和前 100 条记录1-2 个表看起来很好，
- SQL 用户处于无法映射到 SQL 登录的状态（就好像这些用户是在本地数据库中使用“无登录”选项创建的）。在数据库的其他备份中没有发生这种情况。
在这个问题中，我链接到其他人有类似的情况，其本地备份由于磁盘空间不足而损坏：http://www.sqlmag.com/forums/aft/96868
I just lost hours to a corrupt SQL Azure bacpac backup. None of the restore mechanisms I used reported anything wrong when restoring the backup, and schema and data seemed to be there, but given there most definitely was something wrong with that backup.
I'm using Redgate's SQL Azure backup, but afaik all that's is doing is using the create as copy of, checking until it is completed and then using the bacpac export Azure features to take the backup.
Is there a way to confirm a SQL Azure bacpac backup is not corrupt?
More information on the symptoms of the backup:
- Doing a restore through the DAC Framework Client Side Tools or the Azure Management Portal doesn't report any error
- Taking a quick look into the list of tables and the top 100 records of 1-2 tables looked well
- SQL users were left into a state that couldn't be mapped to a SQL login (as if those users were created with the 'without login' option in a local database). This didn't happen in the other backups of the database.
In that question I link to someone else having a similar situation with an on premises backup that was corrupted due to running out of disk space: http://www.sqlmag.com/forums/aft/96868
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
我们将研究对 bacpac 文件输出进行更自动化的检查，可能涉及临时恢复 - 这实际上是检查文件是否完整的唯一方法。在此之前，我们要确保 .bacpac 文件（实际上只是一个 .zip 文件）完好无损并且包含我们期望的数据。
如果您使用其他备份到本地 SQL Server 的机制，我们对此有更多的控制权。
如果您有任何更多想法或要求，请随时给我发电子邮件。 [电子邮件受保护]
We're going to look into more automated checking of the output of the bacpac file probably involving a temporary RESTORE - this is really the only way to check the file is complete. Before that we are looking at ensure the .bacpac file (really just a .zip file) is intact and contains the data we're expecting in there.
If you use the other mechanism of backing up to a local SQL Server we have much more control over that.
Feel free to drop me an e-mail if you have any more ideas or requests. [email protected]