Subject: RE: [Emerald] Upgrade Date: Fri, 12 Dec 2003 10:30:29 -0500 Message-ID: <45B39D99518DEF49AEBBD4769E886D2DC3E3F2@server.studioforpublications.com> From: "John Lord" <lord@allturbo.com>
Thanks that what it was ,im down to 437 megs now
John Lord
It Manager
AllTurbo Internet Services Inc
410-213-9388 Office
www.allturbo.com
-----Original Message-----
From: Jeffrey M Donley [mailto:jeffd@lmf.net]
Sent: Thursday, December 11, 2003 10:07 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] Upgrade
Usually it is caused by your recovery model on the emerald database
causing the transaction log to grow. I had a really good article for
this but can't locate it right now.
If you open you sql query analyzer and run these 2 commands this should
shrink the transaction log to 25 megs.
BACKUP LOG databasename WITH TRUNCATE_ONLY
DBCC SHRINKFILE(databasename_log, 25)
To check if the log file is the problem just go to properties of the DB
and look at the size of the log.
I'll keep looking for the article.
Jeff
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of John Lord
Sent: Thursday, December 11, 2003 9:41 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] Upgrade
On another note , do any of you do any kind of maintance to your sql
databases? I see mine is over 3 gigs now. And I only have 650 mbrs.
John Lord
It Manager
AllTurbo Internet Services Inc
410-213-9388 Office
www.allturbo.com