[dba-SQLServer]Truncate Transaction Log

Billy Pang tuxedo_man at hotmail.com
Wed Aug 13 15:58:08 CDT 2003


Hello:

I have a database using FULL Recovery Model.  The Transaction Log is about 
10 times the size of the Data File.  I just performed a Full Database 
Backup.  How do I reuse the inactive portion of the Transaction Log?

Thanks in advance,
Billy

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail



More information about the dba-SQLServer mailing list