yes, you're correct....sorry about that inaccuracy!

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Tuesday, May 07, 2002 10:32 AM
To: Conahan, Patrick; '[Email Address Removed] [Email Address Removed] RE: shrinking the logs


Backing up the transaction log will cause truncation of the log i.e alll
checkpointed data is deleted; the size of the file is not affected by this.
In order to reduce the size of the log file , you need to run DBCC
SHRINKFILE.

> -----Original Message-----
> From: Conahan, Patrick [SMTP:Patrick.[Email Address Removed] Sent: Tuesday, May 07, 2002 4:18 PM
> To: '[Email Address Removed] [Email Address Removed] Subject: RE: shrinking the logs
>
> won't backing it up shrink it down to the checkpoint?
>
> -----Original Message-----
> From: [Email Address Removed] [mailto:[Email Address Removed] Sent: Tuesday, May 07, 2002 10:11 AM
> To: [Email Address Removed] Subject: shrinking the logs
>
>
> hey guys,,,,i have inherited some unstandard databases,,,and i have been
> trying to clean them up. i have a database that is 45MB and the
> transaction log is 984MB but actually have only 25MB space used. I want
> to make the transaction log 50MB but it is not taking any of my changes.
> How can i change the transaction log to 50MB?
>
> thanks.
> The information in this e-mail, and any attachment therein, is
> confidential and for use by the addressee only. If you are not the
> intended recipient, please return the e-mail to the sender and delete it
> from your computer. Although The Bank of New York attempts to sweep
> e-mail and attachments for viruses, it does not guarantee that either
> are virus-free and accepts no liability for any damage sustained as a
> result of viruses.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page