Re: Database LDF file

From: Tibor Karaszi (tibor.please_reply_to_public_forum.karaszi@cornerstone.se)
Date: 11/29/02 

From: "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
Date: Fri, 29 Nov 2002 11:55:54 +0100

Check out DBCC SHRINKFILE. Also make sure you do regular BACKUP LOG. 

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver"Pupo" <123star@libero.it> wrote in message news:O55GjT5lCHA.2260@tkmsftngp07...
> Hi,
> I see that the .ldf file of a my database has a huge dimension.
> How i can resize or delete this file so it doesn't full all my HD?
> Thank Pupo
>
>

Relevant Pages

  • Re: .LDF files and SharePoint Portal
    ... So when you take a backup of the database, ... I have some questions about .LDF files and Sharepoint. ... Is it safe to delete the data in the .LDF file or will it cause ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Crash Recovery
    ... You can't apply an LDF file to a restored database backup. ... >> How to restore the BAK file. ...
    (microsoft.public.sqlserver.server)
  • Re: Humongous transaction LOG!!!
    ... Just to be clear on this, truncating the Log doesn't shrink the size of the ... it will soon need to use the same amount of space in the .ldf file & it's ... To shrink the .ldf file you can use dbcc shrinkfile. ... This is strange since the size of the backup database is about ...
    (microsoft.public.sqlserver.server)
  • Re: Missing log file...
    ... This will attach the database with MDF file and will create a new LDF file. ... Stop sql server and rename the existing MDF to a new one and copy the ...
    (microsoft.public.sqlserver.server)
  • Re: Clear/Purge Log files
    ... The way you manage your log file is driven by your database recovery plan. ... If your recovery plan is to restore from your last full backup and not apply ... > database to create a new ldf file. ...
    (microsoft.public.sqlserver.server)