No open transactions now. DBCC SQLPERF(LOGSPACE) showed 4.5 Gig. I've shrunk it to 1.5 Gig which should be enough. I need to get more disk !
That was going to be my next suggestion - you definitely need to add capacity somehow. Either grow the LUN for the logs or add a new drive and move some. Good luck.
Jeffrey Williams “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
1. To get rid of th problem the database, where the insert\import operation is bulk should have the T-log bkp should be configured to run frequently to truncate the T-log buffer.
2. Need to check whether any Open Transaction statements are running.
Thanks.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply