Re: Shrink .LDF File
- From: "Maha Arupputhan Pappan" <mahap@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Sep 2005 20:25:34 -0700
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7D26608E-34A0-4EE5-868A-91DC0C0D3C50@xxxxxxxxxxxxxxxx
> > 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.
>
>
>
.
- Follow-Ups:
- Re: Shrink .LDF File
- From: Jose G. de Jesus Jr MCP, MCDBA
- Re: Shrink .LDF File
- References:
- Shrink .LDF File
- From: Maha Arupputhan Pappan
- Re: Shrink .LDF File
- From: Brian Lawton
- Shrink .LDF File
- Prev by Date: Re: Shrink .LDF File
- Next by Date: SELECT Command - For beginner.
- Previous by thread: Re: Shrink .LDF File
- Next by thread: Re: Shrink .LDF File
- Index(es):
Relevant Pages
|
