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 t开发者_运维百科he 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
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?
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......
精彩评论