"SS" <phamunda@hotmail.com> wrote in message news:<6hKcc.4541$%b5.1874@twister.nyroc.rr.com>...
> This seems like it'd be a really stupid question, but for the life of me I
> haven't been able to find an answer that works....
>
> I have a database that's approximately 400MB when shrunk... and the
> transaction logs are at about 4.8GB when shrunk... I can't seem to get the
> transaction log any smaller, no what I try. How can I get the log down
> below 1GB and keep it there? I've only got an 18GB hard drive and I need to
> run 2 copies of this database.
>
> -steve

"SS" <phamunda@hotmail.com> wrote in message
news:6hKcc.4541$%b5.1874@twister.nyroc.rr.com...
> This seems like it'd be a really stupid question, but for the life of me I
> haven't been able to find an answer that works....
>
> I have a database that's approximately 400MB when shrunk... and the
> transaction logs are at about 4.8GB when shrunk... I can't seem to get
the
> transaction log any smaller, no what I try. How can I get the log down
> below 1GB and keep it there? I've only got an 18GB hard drive and I need
to
> run 2 copies of this database.

> This seems like it'd be a really stupid question, but for the life of me I
> haven't been able to find an answer that works....
>
> I have a database that's approximately 400MB when shrunk... and the
> transaction logs are at about 4.8GB when shrunk... I can't seem to get the
> transaction log any smaller, no what I try. How can I get the log down
> below 1GB and keep it there? I've only got an 18GB hard drive and I need to
> run 2 copies of this database.
>
> -steve