Message-ID: <035f01c08581$4b249d20$5038fdce@nckcn.com> From: "NCKCN" <ttuttle@nckcn.com> Subject: Re: [Emerald] 6.73 GB .ldf for Emerald!!! Date: Tue, 23 Jan 2001 15:13:12 -0600
Josh,
I used both Re-organize and Shrink Database files and that did the trick. It
didn't do it immediately but over the course of the night it sure shrunk it
down to a lawbiding size of 377MB.
Thanks,
TKT
----- Original Message -----
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Sent: Monday, January 22, 2001 9:34 AM
Subject: Re: [Emerald] 6.73 GB .ldf for Emerald!!!
> From: "NCKCN" <ttuttle@nckcn.com>
> > It is SQL 7. Just do a shrink database with no special settings. In the
> Ent.
> > Manager it has two options:
> >
> > Re-organize
> > and
> > Shrink Database files...
> >
> > Do I want to have both selected???
>
> I think the last time I did it, I did not select "reorganize".
>
> Josh
>
> > ----- Original Message -----
> > From: "Josh Hillman" <admin-maillist@talstar.com>
> > To: <emerald@iea-software.com>
> > Sent: Monday, January 22, 2001 8:51 AM
> > Subject: Re: [Emerald] 6.73 GB .ldf for Emerald!!!
> >
> >
> > > From: "NCKCN" <ttuttle@nckcn.com>
> > > > I have an index of 6.73GB for Emerald! Is this normal? If not, how
do
> I
> > > > shrink this? The actual database is only 650MB. Any help would be
> > > > appreciated.
> > >
> > > That's rather large to say the least. If this is SQL 7, you can try
to
> > > "shrink the database". If it's SQL 2000, I know nothing about it.
> > >
> > > Josh
> > >
> > > ------------
> > >
> > > This is a user supported list. If you require assistance from IEA
> > Software's
> > > Support Engineers, please check out our Support resources at
> > > http://www.iea-software.com/support.
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> >
> > ------------
> >
> > This is a user supported list. If you require assistance from IEA
> Software's
> > Support Engineers, please check out our Support resources at
> > http://www.iea-software.com/support.
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
> ------------
>
> This is a user supported list. If you require assistance from IEA
Software's
> Support Engineers, please check out our Support resources at
> http://www.iea-software.com/support.
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
.