dbcc shrinkfile, see BOL for details.

>-----Original Message-----
>All,
>
>i have been having a problem removing space from my
transaction log of a
>database, which has grown out of control. i have do the
following things to
>a small effect.
>
>Backing up the database transaction log and the complete
database, this
>clear the transaction log from 10Gb down to 100Mb, but
did not release these
>back to the operating system.
>
>I also tried to shrink the database, by right clicking on
the database and
>selecting shrink database. this only frees up about 2 or
3 Mb at a time.
>
>There is a more violent method of detaching the database
and deleting the
>log file and reattaching, but this is a method that i
would rather not go
>down.
>
>how can i do this effectivley.
>
>Many thanks for any help
>Simon Whale
>
>
>.
>

Report this post to a moderator

also tried this and it only frees up around 10MB per go.

many thanks
simon
"AC" <acui@apotex.com> wrote in message
news:e2b801c2599d$cd331610$36e
f2ecf@tkmsftngxa12...
> dbcc shrinkfile, see BOL for details.
>
> >-----Original Message-----
> >All,
> >
> >i have been having a problem removing space from my
> transaction log of a
> >database, which has grown out of control. i have do the
> following things to
> >a small effect.
> >
> >Backing up the database transaction log and the complete
> database, this
> >clear the transaction log from 10Gb down to 100Mb, but
> did not release these
> >back to the operating system.
> >
> >I also tried to shrink the database, by right clicking on
> the database and
> >selecting shrink database. this only frees up about 2 or
> 3 Mb at a time.
> >
> >There is a more violent method of detaching the database
> and deleting the
> >log file and reattaching, but this is a method that i
> would rather not go
> >down.
> >
> >how can i do this effectivley.
> >
> >Many thanks for any help
> >Simon Whale
> >
> >
> >.
> >

Report this post to a moderator