I have a database that, each night, I pull files from my mainframe and write them to SQL. I first delete the existing file, then pull down the new data from the AS400. I dont know anything about transaction logs, do I HAVE to have em? Can I turn it off on this database? How do I shrink it? I obviously dont need records of all my old table iterations!!
Suggestions are welcome please!