LOG files

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nick (anonymous_at_discussions.microsoft.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 04:55:28 -0700

Your database needs both data files and log files to run.
In order to shrink it you can set your database recovery
mode to full and then backup both the database and the
logfile or you can issue a shrink log file command usiing
t-sql statements.
>-----Original Message-----
>I have an SQL server with data files which have
name_LOG.ldf files much much
>bigger than the data files themselves.
>
>How can I delete them or crunch them?
>
>If I just delete them it appears that the data file can
no loger be read.
>
>Thanks,
>
>Raul Rego
>NJPIES
>rrego.njpies.org
>
>
>.
>

Relevant Pages

  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)
  • Re: Reorg indexes & remove unused space - known problem???
    ... I suspect you're doing a TRUNCATEONLY shrink which doesn't move any data but ... multiple data files that I shrunk to 1% free because some of the data files ... But I now have a database with about 50% fill in ... The time on the removal of unused space is 1 second for ...
    (microsoft.public.sqlserver.tools)
  • Re: PRIMARY filegroup is full - no its not!
    ... sp_helpdb should report the increased size immediately after the ALTER. ... > auto-shrinking, BUT auto shrink is not turned on. ... > large file size after I expand the file using "ALTER DATABASE DataLoad ... > data files by subtracting the reserved space reported by sp_spaceused ...
    (microsoft.public.sqlserver.server)
  • RE: SQL 2005 Ent SP3 migration
    ... change to place database file on any location (SAN, DAS, any location ... DD - SQL server 2005 ... Place different file group on different MDF, and NDF data files. ... The destination disk sizes are already set and I can not change them. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Reorg indexes & remove unused space - known problem???
    ... Leave the database at what ... If you shrink it from there ... available among other data files. ... rebuilt the indexes and removed unused space. ...
    (microsoft.public.sqlserver.tools)