The transaction log is full

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

The transaction log for database 'Database' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Even i cannot delete the rows from sql server, because of this problem

How to solve this problem

Posted 4-Aug-10 0:45am

ypavan

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Goutam Patra · Answer 1 · 2010-08-04T01:13:00

Solution 1

Use those SQL to free log space

BACKUP LOG [LOGNAME] WITH NO_LOG

DBCC SHRINKFILE ([DBNAME],EMPTYFILE)

and read more about Database Recovery Models

Posted 4-Aug-10 1:13am

Goutam Patra

E.F. Nijboer · Answer 2 · 2010-08-04T01:16:00

Solution 2

Right click on the database name and select Tasks -> Shrink -> Database and the the OK button.

Good luck!

Posted 4-Aug-10 1:16am

E.F. Nijboer

The transaction log is full

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

The transaction log is full

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us