RE: Shrinking SQL Server 7 log file

From: Nick Schueler MSFT (nicksch_at_online.microsoft.com)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 06:38:19 GMT

Hi Sujay
Also consider the following articles:

256650 INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/?id=256650

324432 PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work
Because of
http://support.microsoft.com/?id=324432

Nick Schueler
--------------------
| Content-Class: urn:content-classes:message
| From: "Sujay Basak" <anonymous@discussions.microsoft.com>
| Sender: "Sujay Basak" <anonymous@discussions.microsoft.com>
| Subject: Shrinking SQL Server 7 log file
| Date: Fri, 13 Feb 2004 23:51:00 -0800
| Lines: 12
| Message-ID: <1046201c3f2cf$496cb940$a401280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPyz0ls3rEIFscGQVe8pbmlYqUGHg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.mseq
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.mseq:5988
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.mseq
|
| in my database the Auto Shrink option was not selected
| hence the Log file has grown into 8 GB ....
| Now the db cannot be restored from Backup reports error on
| insufficient disk space where as my disk have 30 GB of
| free space.
| Now how can i (1) reduce the log file size,
| (2) restore the db from my backup.
|
| Please help urgently
|
| i have tried shrink database and shrink file option but it
| didnt helped.
|

Relevant Pages

  • Re: how to reduce log file size?
    ... How to Shrink the SQL Server 7.0 Transaction Log ... Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE ... Log File Grows too big ...
    (microsoft.public.sqlserver.server)
  • Free Space vs. Fully Shrunk?
    ... In my opinion its good to shrink but only when it does not ... impare performance. ... SQL Server to request disk space, ... There are a couple of tricks though to keep the log file ...
    (microsoft.public.sqlserver.programming)
  • Re: dbcc reindex & dbcc shrinkdatabase?
    ... An increase in the data file is acceptable but not the log file. ... started testing out is scheduling the "dbcc reindex", ... not much free space to reclaim. ... this does indeed shrink the virtual logs size, ...
    (microsoft.public.sqlserver.server)
  • Re: Database/Logs dont shrink with Maintenance Task
    ... Only a shrink file can do that but it may require a backup to get ... Other wise it has to keep growing to make room for more transactions. ... the log file smaller--whether you shrink or not? ...
    (microsoft.public.sqlserver.setup)
  • Re: Detach - Attach in SQL Server 7
    ... >> It is not rquired to detach and attach the database to shrink the file. ... If the log file really huge make the databse single user after ... >> DBCC SHRINKFILE('Logical_ldf_name','truncateonly' ...
    (microsoft.public.sqlserver.server)