asked on

The transaction log for database ‘xxxx’ is full.

Hi,
How do I fix "The transaction log for database ‘xxxx’ is full" if I get it after deleting huge data?

Thanks.

Ephraim Wangoya

You ran out of disk space and the log can't grow anymore.
You need more space

SOLUTION

FredTang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

JoeNuvo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

arunbhatt

ASKER

Hi,
Can transaction log file be shrink using recovery model full?

Thanks.

arunbhatt

ASKER

Hi,
When database is backed up: the log is backed up and log truncated. Is that true?

Thanks.

SOLUTION

JoeNuvo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ElectricLlama

You can also delete and commit smaller chunks of data. Assuming you have some kind of key that ets you selectively delete chunks:

BEGIN TRAN
DELETE YourTable WHERE Key BETWEEN 1 AND 1000
COMMIT TRAN

BEGIN TRAN
DELETE YourTable WHERE Key BETWEEN 1001 AND 2000
COMMIT TRAN

Steve Wales

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.