CODEWITHSUNDEEP
sql-serverbackupetl
alex
alex

Reputation: 755

SQL Server ETL process transaction logs

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

Upvotes: 1

Views: 552

Answers (1)

gbn
gbn

Reputation: 432271

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?

Upvotes: 1

Related Questions