John Mitchell-245523 (4/29/2013)
Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up. You have several options:(1) Allow more space for your transaction log
(2) Back up your log more frequently during index maintenance
(3) Use an index maintenance script that only rebuilds or reorganises indexes that are fragmented.
John
Hi John,
Consider a scenario where in..
u have to Create a DB & then backup the Logs every day... then what would you suggest for the mdf & ldf files to be.. in terms of Size..
Like while creating the DB.. in properties u have an option to change & set the size..
1) Initial Size
2) AutoGrowth..
Please suggesta best method of setting this for smooth execution...
************************************
Every Dog has a Tail !!!!! :-D