"Maha Arupputhan Pappan" wrote:

> Dear Brian,
>
> I tried this command before posting this question in the Community
> Newsgroup. Unfortunately, there is no success and the file size remains the
> same. However, when I checked the file this morning (Tuesday, 06-Sep-05 @
> 1030hrs) the file is shrunk.
>
> Best Regards,
> --
> Maha Aruppthan Pappan
> Nacap Asia Pacific (Thailand) Co., Ltd.
>
>
> "Brian Lawton" wrote:
>
> > You are looking for the DBCC SHRINKFILE command. See books-online for usage
> > examples.
> >
> > --
> > --Brian
> > (Please reply to the newsgroups only.)
> >
> >
> > "Maha Arupputhan Pappan" <mahap@discussions.microsoft.com> wrote in message
> > news:7D26608E-34A0-4EE5-868A-91DC0C0D3C50@microsoft.com...
> > > Dear All,
> > >
> > > The SQL Server 2000 in my network is hosting many database for many
> > > business
> > > units within the organization. The server is heavily used for data
> > > collection
> > > and web hosting.
> > >
> > > One of the .LDF file has grown very fast and I am very sure that it is
> > > impossible for the file to grow that huge within 1 month.
> > >
> > > Please assist me how to reduce its file size. It is now 75GB. Other .LDF
> > > files weighs at only 10M or 50Mthe max.
> > >
> > > Your assistance will be appreciated.
> > >
> > > Regards,
> > > Maha
> > > --
> > > Maha Arupputhan Pappan
> > > Nacap Asia Pacific (Thailand) Co., Ltd.
> >
> >