October 31, 2003 at 6:39 am
Hi,
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.
Madhu
Madhu
October 31, 2003 at 8:58 am
how many times /week/day you load the data?
If 1,2,3/week change the option model for the database to Bulk-Logged
and make sure you do a backup log after the transaction is done and a full backup after
regards lmt
PS Put an alert on that log file as well!
November 3, 2003 at 12:32 pm
Can you not break the update into smaller chunks?
Isaiah
-Isaiah
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply