🚀 go-pugleaf

     I have also noticed that my disk space information (in SQLAdmin under
devices) does not match the actual space on the disk on my NT server.  How
do you get an accurate (consistent) accounting of both of these resources
(logspace and "device space")?

 ----------
From: MSSQL-L
To: Multiple recipients of list MSSQL-L
Subject: Re: Transaction Log Filling Up
Date: Tuesday, May 09, 1995 9:48AM

In article <MSSQL-L%95050815201311@DUKEFSB.BITNET> Jonathan Shewbridge
<usatljps@IBMMAIL.COM> writes:
>Date: Mon, 8 May 1995 15:00:22 EDT
>From: Jonathan Shewbridge <usatljps@IBMMAIL.COM>
>Subject: Transaction Log Filling Up

Jon,

Try doing a DBCC Checktable on the syslogs table.  I did this using SQL
Administrator, using the "System" button and the DBCC menu choice under
Manage
and selected Check Tables and then syslogs in the master db.

You might also try a DBCC sqlperf(logpsace) in the query window of SQL
Administrator.

It appears that SQL Server does not acurrately update the db information
about the log space after a DUMP TRANSACTION WITH NO_LOG (or TRUNCATE_ONLY)
and I've found that I need to do the steps above to get an accurate (?)
value
to display the correct values.

Allen.

greera@ucs.orst.edu


>We are having a problem with a transaction log filling up while we are
working
>with SQL Server in a pilot environment.  The database has 2000 MB of data
space
>and 600 MB of log space.  I have attached the specifics from SQL
Administrator.
>Is there a Transact-SQL command which displays the current amount of free
space
>remaining in the log?

>We are using the following command to backup the database:
>        dump database testoffice to tapedrive with nounload, noinit
>I was under the impression that this command would clear out the log, but
that
>does not seem to be the case.  Even
>        DUMP TRANSACTION testoffice WITH NO_LOG
>only seems to free up 14 KB (see "Unused Log Space: 14 KB" below).  What am
I
>missing?

>TIA,

>Jon
























































>===========================================================================
>Jonathan Shewbridge             Voice:  (703) 989-3300
>usatljps@ibmmail.com            Fax:    (703) 772-4116

>Atlantic Mutual Companies
>1325 Electric Road
>Roanoke, VA 24018  USA
>===========================================================================

 -------------------------------------------------------------------
Allen Greer                      Internet: greeral@ccmail.orst.edu
SIS System Integrator, Info Serv    Phone:          (503) 737-2671
Oregon State University, Milne 202    Fax:          (503) 737-4484
Corvallis, OR 97331-5202
WWW: http://www.bus.orst.edu/faculty/greer/greer.htm