使用 filstream 文件组分段恢复数据库
我尝试过备份包含文件流的数据库，效果很好。我也尝试过在其他服务器上恢复它，这也有效。
现在，我面临一个问题。我们的数据库很大（约 320 GB），备份和恢复需要时间。因此，客户希望我们建议一些技术来减少时间。
我尝试过分段恢复，它允许您备份和恢复数据库中的各个文件组。它可以与除文件流文件组之外的所有其他文件组一起正常工作。我能够进行备份但无法恢复它。
你有什么想法吗？
问候，
普拉尚特。
I have tried taking the backup of database containing filestream and it works fine. I have tried restoring it on other server also and that works too.
Now, i am facing a problem. Our database is big in size (approx. 320 GB) and it takes time to backup and restore it. Therefore, the client wants us to suggest some technique to reduce the time.
I have tried piecemeal restore which allows you to backup and restore individual filegroups in the database. It works fine with all the other filegroups except for Filestream ones. I am able to take backup and not able to restore it.
Do u have any idea??
Regards,
Prashant.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
通过将数据库的恢复模式更改为完整，然后进行备份并使用恢复属性恢复它们，解决了上述问题。
谢谢，
普拉尚特。
The issue mentioned was solved by changing the recovery model of the database to Full and then taking backups and restoring them with Recovery attribute.
Thanks,
Prashant.