MSSQL Server Transaction Log "Stuck" at 20MB

Article View: alt.comp.databases

Article #60

Back to alt.comp.databases Previous Next

#60

From: Glenn R. Kurban
Date: Wed, 15 Apr 1998 00:00

14 lines
1255 bytes

This is probably a fairly common problem since it has happened to me 
before resulting in my having to restore a whole database (testing 
database, luckily); however, I have never received a solution for it.

The transaction log in one of my development databases ran out of log 
space completely (zero, zilch, nada...)  Upon truncating the log with 
'no_log,' I was left with only 20MB of a 148MB log for me to work with.  
Nothing I try will free-up the rest of my transaction log. DBCC opentran 
shows NO open transactions...I dont know what to do.  Please, any help 
would be greatly appreciated.

Thanks,
Glenn K.

Technical Details

Message-ID: <MPG.f9ef4a1f267a17989680@news.earthlink.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10a90d,6bf473bf598b834,start
X-Google-Attributes: gid10a90d,public
X-Google-Thread: 104de1,6bf473bf598b834,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,6bf473bf598b834,start
X-Google-Attributes: gidf6611,public
From: gkurban@earthlink.net (Glenn R. Kurban)
Subject: MSSQL Server Transaction Log "Stuck" at 20MB
Date: 1998/04/15
Message-ID: <MPG.f9ef4a1f267a17989680@news.earthlink.net>
X-Deja-AN: 344454959
Organization: EarthLink Network, Inc.
Newsgroups: alt.comp.databases,bit.databases.mssql-l,comp.databases.ms-sqlserver