I need to create a couple of snapshot tables that will export a large amount of data. While running a few tests, I need to create the table, import data, inspect the results, update the export query and then delete all the data in the table and start over.
The table, when finished, will be moderately large but dropping and reloading the data again and again is making the transaction log file MASSIVE.
What I would like to do is cut off transaction logging for these files until I'm satisfied with my results, or clear the transaction log for the table. To be clear, I do not want to cut off logging for the entire database. This is a shared, developer DB and we need to keep the log running.
I need to create a snapshot process that pulls certain data from a massive audit table on our production server. I want to move the pertinent data to our dev server, and create a process that can run nightly/weekly to get the most recent changes. However, I need to do an initial population from the full audit table. I'm new to the company and I do not know anything about their data structures. Thus, I need to pull the data, do a bit of analysis and then fine-tune my queries.
Can this be done? I've tried to Google this multiple ways and multiple ways but I can't find anything related to table-specific transaction log settings.