We're consolidating data from a bunch of databases into four reporting databases each night.
Because the entire dataset is imported each night we do not need to be able to restore the data to a point in time. Thus the databases are in simple recovery mode.
Each time we run the import however, our database
ldf files grow to absurdly large sizes (50+ Gigs).
Is there a way to turn off the logging altogether or get SQL Server to clear those log files sooner?
I'm guessing no for clearing as the