We have a database with a huge amount of data in the Change Log table (60GB). Is there a way to use SQL command to drop the table without having it write to the transaction log?
Or you can run a procedure that runs every N minutes and deletes the N oldest records. You will have to run that for a long time. I always do something like that instead of deleting all in 1 big go.
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Yeah, usually the a job is run to archive the data into a different database / table. If you don't need to preserve the data, though, I recommend the TRUNCATE.
BTW - You cannot use "Truncate Table" on a table that is used by an Indexed View. So if you have defined any SumIndexes on the table you won't be able to use "Truncate Table".
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book