Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Sean_B
Posting Yak Master
111 Posts |
Posted - 2009-08-13 : 04:02:39
|
Hi,I've been running an incremental update on a very large table, updating it in batches of about 100,000 records each time. Yet I have still run out of transaction log space, a few hours into the update, almost as if it was all being done in the same transaction. I'm running this update from a management studio window, I notice that when I look in the activity monitor window there appear to be 2 transactions open, I'm not sure why ?Is there something extra I might need to do to clear down the transaction logs whilst this process is running ?Any suggestions about what I should check wouild be appreciated.Sean |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-08-13 : 04:43:27
|
What recovery model is the DB in?--Gail ShawSQL Server MVP |
|
|
Sean_B
Posting Yak Master
111 Posts |
Posted - 2009-08-13 : 04:55:25
|
It was in bulk-logged when the problem happened, I'm rerunning at the moment in simple, and it seems to be running ok, so far.Sean |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-08-14 : 03:53:01
|
In Bulk-logged or full recovery, a transaction log backup is required to make the log space reusable. In Simple the regular checkpoint process will do that.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|