August 28, 2008 at 8:07 am
I have found several posts which answer parts of my question but none which address it completely so I unfortunately have to add yet another post on this topic.
I am running SQL Server 2000 SP4.
I have a production database of approx. 100 GB.
When I run the DBCC REINDEX function via a Maintenance Plan, the transactionb log file expands to approx. the size of the database.
Eventually, I will run out of space on the device on which the transaction log resides.
I would like to continue to run the reorg. process unattended and do not want to mess with changing the recovery model.
The reorg. section of the Maintenance Plan runs for approx. 4 hours.
My Question:
If I schedule log file backups to run every 30 minutes during this time period, will this cause space in the log file to be re-used, keeping the physical log file size in, say, the 25-50 GB range?
I backup log files directly to tape so disk space for the backup is not an issue.
September 4, 2008 at 4:48 pm
Other option: Drop and recreate the index. This takes up less t-log space.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply