From: "Jeffrey M Donley" <email@example.com> Subject: RE: [Emerald] SQL Help.. Date: Wed, 30 Oct 2002 10:49:26 -0500 Message-ID: <GAEHIKBCFLDAOHNDPKGCKEEECPAA.firstname.lastname@example.org>
Run these in your sql analyzer
BACKUP LOG <database name> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(data base name_log, 25)
This will truncate the unused portion of your log file, Then shrink the log
to 25 MB
[mailto:email@example.com]On Behalf Of Craig Hulbert Sent: Wednesday, October 30, 2002 10:22 AM To: firstname.lastname@example.org Subject: [Emerald] SQL Help..
I posted this before and got no answer.. I can't be the only
person that has concern over the SQL Server emerald.ldf file
size.. its at 5GB now and I would like to prune it... any cluse..
besided the MS Method that doesn't work...
Sent via the WebMail system at daytondigital.net
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
For more information about this list (including removal) go to: