won't backing it up shrink it down to the checkpoint?

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Tuesday, May 07, 2002 10:11 AM
To: [Email Address Removed] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page