August 28, 2008 at 11:24 am
*** I am reposting this as I previously put it in the wrong section ***
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.
August 28, 2008 at 12:52 pm
You just need to make sure that database has 1.5 times the largest table size free space available in it. Reindex operation needs that as it will recreate the table and its indexes.
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply