SQL Server ETL 处理事务日志
是否可以在临时数据库中为 ETL 过程设置简单恢复模式...客户甚至没有进行定期备份!那么保留事务日志有什么意义...
我建议在批量导入后组织每日备份,仅此而已...
有什么反对这个计划的吗?而且 3 周后交易日志大小为 80GB...
干杯
is it ok to set recovery mode simple in a staging db for an ETL process... The customer is not even doing a regular backup! So what's the point in keeping the transaction logs...
I propose to organize a daily backup after the bulk import and that's it...
Anything against this plan? Also the transaction logs were at 80gb after 3 weeks...
cheers
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
是的,我会使用简单模式。事实上,我确实...
数据不需要“时间点恢复”,所以让自己的生活更轻松。您甚至需要完整备份吗?
Yes, I would use simple mode. In fact, I do...
The data does not require "point in time recovery" so make life easier for yourself. Do you even need a full backup?