Dbcc shrinkfile

to check log size and percentage usage use

Dbcc sqlperf(logspace)

This will give the log file size and percentae usage for the server

Deepak

-----Original Message-----
From: Chris Kempster [mailto:[Email Address Removed] Tuesday, May 07, 2002 8:52 AM
To: [Email Address Removed] RE: shrinking the logs


Backing up wont change the size, the restore will restore
the files back to their existing size. Consider
running the following:

dbcc shrinkdatabase(N'mydb', TRUNCATEONLY )
exec sp_spaceused

also try

DBCC shrinkdatabase(N'BUYSMART')
exec sp_spaceused

OR

read up on attaching and de-attaching, you can re-attach via
the single file method and not specifying a log file, this
will create a new log file of 512k, you can then reset its
physical size to 50mb if need be.

-----Original Message-----
From: Conahan, Patrick [mailto:Patrick.[Email Address Removed] Tuesday, 7 May 2002 11:18 PM
To: '[Email Address Removed] [Email Address Removed] 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] 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] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page