MS SQL Server Database Option - Transaction Log I have a database for staging purpose before move into another main database. It has 5-6 millions records on average. The transaction log keep growing after few days to 30-40 gig. The transaction record not important because I can retrieve from my source again if needed. There are some configuration details needed only.
What's the best way to manage transaction log ?
What database recovery mode should I set - Simple, Full, Bulk Logged ? By default, I selected Full.
Should I just schedule a job to purge the transaction log on a daily basis ?
Any recommendation ? Thanks.
The transaction record not important because I can retrieve from my source again if needed.
. . .
What database recovery mode should I set

SIMPLE.  Then shrink the log one time.