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.


MS Sql Server LazyDBA home page