SQL数据库备份和还原策略 [英] SQL Database Backup and restore strategy

问题描述

我正在准备备份&恢复生产数据库的策略，大小约为10TB，并且有大约50个以上的文件组。

I am preparing the backup & restore strategy for production database which is around 10TB in size and it has around 50+ file groups.

我计划实施完全备份，但有一个更多关于使用FG备份的说法，这在性能方面有点好，但在FG备份和实现方面存在问题。恢复将在处理更长时间时变得复杂。

I was planning to implement Full back up but there is one more argument to use the FG backup which is little bit good in performance but the issue in implementation of FG backup & restore will be complicated in handling for longer run .

请建议

推荐答案

我正在准备备份&恢复生产数据库的策略，大小约为10TB，并且有大约50个以上的文件组。

I am preparing the backup & restore strategy for production database which is around 10TB in size and it has around 50+ file groups.

我计划实施完全备份，但有一个更多关于使用FG备份的说法，这在性能方面有点好，但在FG备份和实现方面存在问题。恢复将在处理更长时间时变得复杂。

I was planning to implement Full back up but there is one more argument to use the FG backup which is little bit good in performance but the issue in implementation of FG backup & restore will be complicated in handling for longer run .

请建议

有什么问题  ;参数？

你究竟有什么问题？
你能提供你想到的查询

What is the problematic argument?
What is the issue exactly which you have
Can you provide the query which you thought about

这篇关于SQL数据库备份和还原策略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！