Re: MSSQL Server Transaction Log "Stuck" at 20MB

Article View: alt.comp.databases

Article #61

Back to alt.comp.databases Previous Next

#61

From: asdf
Date: Wed, 15 Apr 1998 00:00

20 lines
1507 bytes

Try dbcc checktable(syslogs).  It may be that sysindexes are not reflecting
the true space available.

Glenn R. Kurban <gkurban@earthlink.net> wrote in article
<MPG.f9ef4a1f267a17989680@news.earthlink.net>...
> 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: <01bd68c1$91adb860$91ca06d0@KGBHome95>

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

References: <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: 10a90d,6bf473bf598b834
X-Google-Attributes: gid10a90d,public
X-Google-Thread: f6611,6bf473bf598b834
X-Google-Attributes: gidf6611,public
From: "asdf" <kgb@magicnet.net>
Subject: Re: MSSQL Server Transaction Log "Stuck" at 20MB
Date: 1998/04/15
Message-ID: <01bd68c1$91adb860$91ca06d0@KGBHome95>
X-Deja-AN: 344466529
References: <MPG.f9ef4a1f267a17989680@news.earthlink.net>
Organization: Just Me
Newsgroups: alt.comp.databases,bit.databases.mssql-l,comp.databases.ms-sqlserver

Reply to Parent Message