Re: SQL Server LOG file Problem

Article View: bit.databases.mssql-l

Article #2018

Back to bit.databases.mssql-l Previous Next

#2018

From: Emil Chan
Date: Tue, 04 Apr 1995 00:00

15 lines
1101 bytes

>I ran into the same problem.  SQL Server doesn't seem to update the size of the
>log file when it should.  Trying doing a DBCC Checktable on your syslogs table.
>Also if you do a Manage|Database|Properties|Full in the MS SQL Adminstrator you
>shoudl get back accurate info about the log size.  I think that doing the DBCC
>on syslogs will help SQL Server realize the actual size of the table though.
>
Hi Allen,

Many thanks for your valuable advice, it solves my problem now.


Cheers:)

Emil Chan
emilchan@asiaonline.net

Technical Details

Message-ID: <9504040200.AA28030@asiaonline.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: f6611,b2d6a589230c5b57
X-Google-Attributes: gidf6611,public
From: Emil Chan <emilchan@ASIAONLINE.NET>
Subject: Re: SQL Server LOG file Problem
Date: 1995/04/04
Message-ID: <9504040200.AA28030@asiaonline.net>
X-Deja-AN: 100850615
sender: Microsoft SQL Server Discussion List
x-sender: emilchan@asiaonline.net
comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
content-type: text/plain; charset="us-ascii"
mime-version: 1.0
newsgroups: bit.databases.mssql-l
x-mailer: Windows Eudora Version 1.4.4