[dba-SQLServer]SQL LOG File is Huge! 10GB - Help

Julie Reardon-Taylor prosoft6 at hotmail.com
Wed Oct 8 10:34:31 CDT 2003


Thanks Eric.  I already have the shrinking and re-indexing in place to occur 
before I back up the transaction logs.  It looks like the database is 
corrupt and is causing massive bloating.  Cannot see why this occurred, but 
it happened overnight.  Anyone have this problem before?

The transaction logs are backed up every two hours, with the databases 
backed up in the PM, shrunk and re-indexed every night.



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net

_________________________________________________________________
Instant message in style with MSN Messenger 6.0. Download it now FREE!  
http://msnmessenger-download.com



More information about the dba-SQLServer mailing list