We are updaing a table with some other tables in same database. The table contains 20 lakhs records which is going to be updated. During updating the table Log file is drastically increasing. Total free space in C drive is 4 gb. Log file is resided in C drive. And Database recovery plan is Simple mode. No check point is issueing.
If total free space is more that 4GB then the update query will be succeded, other wise, free space will be decreased til 0MB. so, We have to moitor it continuously till the query completion. To reduce the increased log file during the update query. what could we do??
I am tying to run this update quey batchwise. what is your suggestion??
Thanks in advance.