Re: Cannot shrink database log

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

From: San (anonymous_at_discussions.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 15:11:06 -0700

Thanks Dinesh...This indeed worked

The script presented to wrap aroun the tx log help solved it..!
Microsoft Knowledge Base Article - 256650
INF: How to Shrink the SQL Server 7.0 Transaction Log

Thanks once again for all your valuable help.

San

Relevant Pages

  • Re: Changing database size
    ... It seems like you are saying that you can shrink the ... size of a database file using ALTER DATABASE without the usage of DBCC ... transaction log files renders corrupt databases. ... How to Shrink the SQL Server 7.0 Transaction Log ...
    (microsoft.public.sqlserver.server)
  • Re: AutoShrink Database Transaction Log
    ... Shrink implies actually reducing the amount of space used by the actual OS ... There is not a check box setting to autoshrink the log and not the database. ... > I am using SQL Server 2000 Enterprise Edition with SP3A. ... > Is there away that can I autoshrink the database> transaction log and not the database? ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Transaction log keeps growing
    ... Introduced in SQL Server 7.0 was the ability automatically grow and to ... shrink the physical size of database data and transaction log files. ...
    (comp.databases.ms-sqlserver)
  • Re: Assigned Space
    ... How to Shrink the SQL Server 7.0 Transaction Log ... INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE ...
    (microsoft.public.sqlserver.server)