How to truncate and reload a large table in SQL Server without generating transaction logs
Posted on 2013-01-29
I have a large table (1,000,000+ rows) in a SQL Server 2005 database that I truncate and reload from scratch 3-5 times per week. This table is for reporting purposes only and the data in this table does not need to be restored in the event of a system failure (I can easily restore the data by rerunning the program that normally truncates and reloads it).
Whenever I do this, there are a lot of transactions generated and my transaction log grows very large.
Is there a way to load this table without generating all of the transaction logs?
In Oracle, I would create the table as "UNRECOVERABLE" or with "NOLOGGING".
Is there something similar for SQL Server?