How to Disable Log File in SQL Server 2008
Posted on 2012-09-07
I'm doing a massive data manipulation on my SQL database, and this is causing the log file to grow very rapidly beyond the available storage space. As a result, the data manipulation task stops in the middle because the server runs out of space and I'm unable to finish the task.
I can do:
DBCC SHRINKFILE ('myLogFile' , 0, TRUNCATEONLY)
and reduce the size of the Log down to 1,024 KB, but this is only possible after the task is over.
Is there any way I can disable logging the data transactions or perhaps force the log file to shrink during the operation to ensure that my massive data processing runs to the end without interruption.
Appreciate your help,