Re: Shrink .LDF File

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.


.

Relevant Pages

  • Shrink .LDF File
    ... The SQL Server 2000 in my network is hosting many database for many business ... One of the .LDF file has grown very fast and I am very sure that it is ... Maha Arupputhan Pappan ...
    (microsoft.public.sqlserver.datamining)
  • Re: Open mdf in SQL server 2005
    ... I detach in sql server 2000 and I attach in SQL server and it works. ... to have the LDF file, ... Now I would like to convert open the mdf file in sql server 2005 and I ... I attach but appears an error: Fail to retrive data for this request. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Can I replace 120 day Eval with Personal Edition?
    ... Can you install SQL Server 2000 personal edition. ... Copy the MDF and LDF file to correct directory ... MDF and LDF as a database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Shrinking database, simple model
    ... Replicated Transaction Information: ... In normal conditions LDF file isn't so big, ... We tried to shrink LDF, and after shrinking we got LDF about 7GB. ... model SQL server will do it by itself? ...
    (comp.databases.ms-sqlserver)
  • Re: Shrinking database, simple model
    ... In normal conditions LDF file isn't so big, ... We tried to shrink LDF, and after shrinking we got LDF about 7GB. ... model SQL server will do it by itself? ... First, if the log file keeps growing to 15 GB, let it be that size. ...
    (comp.databases.ms-sqlserver)