Article View: alt.comp.databases
Article #63Re: MSSQL Server Transaction Log "Stuck" at 20MB
From: Peder Holst
Date: Thu, 16 Apr 1998 00:00
Date: Thu, 16 Apr 1998 00:00
21 lines
1661 bytes
1661 bytes
Glenn, After you tried everything - what did the DBCC checktable (syslogs) statement return ? Peder Holst http://www.elektrosoft.com Glenn R. Kurban wrote in message ... >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:
<892727149.406897@mn8>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<MPG.f9ef4a1f267a17989680@news.earthlink.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 104de1,6bf473bf598b834 X-Google-Attributes: gid104de1,public X-Google-Thread: f6611,6bf473bf598b834 X-Google-Attributes: gidf6611,public X-Google-Thread: 10a90d,6bf473bf598b834 X-Google-Attributes: gid10a90d,public From: "Peder Holst" <pederh@elektrosoft.se> Subject: Re: MSSQL Server Transaction Log "Stuck" at 20MB Date: 1998/04/16 Message-ID: <892727149.406897@mn8> X-Deja-AN: 344631714 Cache-Post-Path: mn8!s-14508@dialup172-4-27.swipnet.se References: <MPG.f9ef4a1f267a17989680@news.earthlink.net> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 X-Complaints-To: news-abuse@swip.net X-Trace: mn5.swip.net 892727149 5401 (None) 192.71.180.98 Organization: A customer of Tele2 Newsgroups: alt.comp.databases,bit.databases.mssql-l,comp.databases.ms-sqlserver