log

I get an error message:
"Msg 9002, Level 17, State 2, Line 1
The transaction log for database 'My_db' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column
in sys.databases"
The collumn log_reuse_wait_desc says: LOG_BACKUP
There is not much free space on the file server. How can I force or
set the option so that I can run the query? I don't need any backup
(data or log) either.
Thanks.On Jun 6, 4:35 pm, SB <othell...@.yahoo.com> wrote:
> I get an error message:
> "Msg 9002, Level 17, State 2, Line 1
> The transaction log for database 'My_db' is full. To find out why
> space in the log cannot be reused, see the log_reuse_wait_desc column
> in sys.databases"
> The collumn log_reuse_wait_desc says: LOG_BACKUP
> There is not much free space on the file server. How can I force or
> set the option so that I can run the query? I don't need any backup
> (data or log) either.
> Thanks.
I did try to shrink the log (and data) but the problem persists
(LOG_BACKUP).|||SB wrote:
> On Jun 6, 4:35 pm, SB <othell...@.yahoo.com> wrote:
>> I get an error message:
>> "Msg 9002, Level 17, State 2, Line 1
>> The transaction log for database 'My_db' is full. To find out why
>> space in the log cannot be reused, see the log_reuse_wait_desc column
>> in sys.databases"
>> The collumn log_reuse_wait_desc says: LOG_BACKUP
>> There is not much free space on the file server. How can I force or
>> set the option so that I can run the query? I don't need any backup
>> (data or log) either.
>> Thanks.
> I did try to shrink the log (and data) but the problem persists
> (LOG_BACKUP).
>
Hi,
You'll need to backup the log file in irder to free up some space within
the file. If you run the BACKUP LOG command with the NO_LOG option, it
will truncate your logfile and free up some space.
Once you've done that, I suggest that you either do a regular backup of
the log or set the database in SIMPLE recovery mode. In that case it
will truncate the log automatically.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator