Re: sqlmaint Question

From: kevinsharp69 (kevinsharp69_at_discussions.microsoft.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 10:21:01 -0800

Actually i'm not looking for it to shrink the file but actually clear the
transactions that have been backed up. Previous to the backup the log was
fixed at 60MB and 8.9MB was used, after the backup there was still 8.9MB used.

"pdxJaxon" wrote:

> it's not going to shrink the file and in fact, you probably dont want it to
> as Re-Growing the file later is an expensive operation.
>
> If you REALLY Need to shrink the file you can use:
>
> DBCC ShrinkFile
> or
> DBCC ShrinkDatabase
>
>
> Greg Jackson
> PDX, Oregon
>
>
>

Relevant Pages

  • Re: Merge Replication of large database
    ... Backup the transaction log and then issue a shrink. ... Also issue a dbcc opentran to see if there are any open transactions. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • 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: Fragmentation Issues
    ... checkalloc if you just ran CheckDB since that is included in checkDB. ... always do a regular log backup so you can use it for what is intended for. ... And lastly don't shrink your database. ... > dbcc showcontig ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Shrink issue
    ... you can't take a transaction log backup when your database in SIMPLE Recovery Model. ... shrink on the .ldf DB's in full mode? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Transaction log too big
    ... Think of the backup file as a physical file. ... Each time you do log backup, ... > So I think only a shrink could reduce it's size because backup log doesn't reduce it. ... There are no problems in performing a DBCC SHRINKFILE as such. ...
    (microsoft.public.sqlserver.server)