Eric Barro
ebarro at afsweb.com
Mon Sep 6 15:23:45 CDT 2004
John, Here's what I had posted earlier to deal with the growing log file issues... Overview: You will need to restrict the growth of the transaction log file and then set up a backup schedule for the log file followed by a shrink log file operation. 1. Right click on the database and then go into Properties. 2. Click the Transaction Log tab 3. Make sure to restrict file growth to a manageable size where your drive won't run out disk space 4. Click Options tab 5. Check the Auto shrink checkbox. This will allow SQL server to automatically shrink your database and log files to the minumum required. 6. Click OK and apply all those changes. 7. Go into the Management section of EM. 8. Select Backup 9. Create a backup set for your log files. Select the db, check Transaction Log radio button. Select destination and check the schedule box and specify when you want it to run. Depending on the amount of activity and the maximum amount you specified for the log file to grow you will need to specify a scheduled backup and shrink operation that will suit your needs. On our production environment I had it set to 1 hr intervals. 10. Set up a scheduled shrink log file operation. --- 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 John W. Colby Sent: Monday, September 06, 2004 10:44 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] HELP - Log file growing rapidly I am importing this data into the server. The log file is growing rapidly. It is currently at 23g, where the 4 data files are around 13g each. Is this natural or is it growing this rapidly because I am importing simultaneously from the 4 different machines? With 144g of free space on the drive that the log file is on, I am in no danger of running out of room, certainly not before the current set of imports finish. However it appears that I do need to figure out how to backup the log files so that I can re-use the room for the next set of imports. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com