SQL Server LOG file Problem

Article View: bit.databases.mssql-l

Article #2004

Back to bit.databases.mssql-l Previous Next

#2004

From: Emil Chan
Date: Mon, 03 Apr 1995 00:00

35 lines
1532 bytes

Following is the Properties List of my database BLBDATA.  No matter how hard
we tried, the Log Space Used is still as big as 270Mb!  I did try using Dump
Database, Dump Transaction with truncate and with no_log but still does not
help.  The Log used to store together with the data segment master, I tried
to altered it to the new device LogDev but doesn't help neither.

Could anybody help?

Database Properties: BLBDATA on BLBHK_S1 as of 04/03/95 11:52:23
Number of Users: 1
Number of Groups: 1
Options Set: no options set
Reserved Space: 275098 KB
Data Space Used: 274502 KB
Log Space Used: 271520 KB
Index Space Used: 132 KB
Unused Reserve: 464 KB
Unused Log Space: 8 KB

Device                              Size
Usage

LogDev                              100 MB
log only
master                              250 MB
data only
master2                             300 MB
data only

TIA.

Cheers:)

Emil Chan
emilchan@asiaonline.net

Technical Details

Message-ID: <9504030553.AA25150@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,start
X-Google-Attributes: gidf6611,public
From: Emil Chan <emilchan@ASIAONLINE.NET>
Subject: SQL Server LOG file Problem
Date: 1995/04/03
Message-ID: <9504030553.AA25150@asiaonline.net>
X-Deja-AN: 100734953
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