Eric Barro
ebarro at afsweb.com
Wed Aug 13 16:15:05 CDT 2003
Billy, You need to shrink the Tlog. I would make sure that the Tlog doesn't grow over a certain size or it will eat up all the disk space you have. Depending on the volume of transactions you might want to back up the Tlog on a regular schedule and then schedule a job to shrink it every night. You will probably have to go through several shrink operations before you are able to recover back all the unused space. --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy Pang Sent: Wednesday, August 13, 2003 1:58 PM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]Truncate Transaction Log 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003