November 8, 2006 at 11:01 am
I was just testing one of our old VB6 applications against a SQL Server 2005 database that we upgraded a couple of months ago, when I got the following error message:
The transaction log for database 'OurDatabase' is full.
To find out why space in the log cannot be reused,
see the log_reuse_wait_desc column in sys.databases.
So I ran a query against that log_reuse_wait_desc column and got the following:
| log_reuse_wait_desc | |
|---|---|
| 1 | NOTHING |
| 1 | NOTHING |
| 1 | LOG_BACKUP |
| 1 | CHECKPOINT |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | LOG_BACKUP |
| 1 | NOTHING |
I don't know what this is telling me, so I would certainly appreciate some help with it, please.
Kindest Regards, Rod Connect with me on LinkedIn.
November 8, 2006 at 1:14 pm
I believe that column tells you why your log can't be truncated at this time.
Here's a link that may help you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply