SQL-7 EXPERTS - Shrink and Truncate
Posted on 2001-06-15
Could someone please indicate the best way to use 'AUTO SHRINK' and 'TRUNCATE LOG ON CHECKPOINT' options?
Can Auto Shrink work without selecting the Truncate Log on CheckPoint option?
Does Auto Shrink shrink both the database and the tlog?
Are any transactions actually deleted by Auto Shrink or does it just eliminate the unused space in transaction log and database?
If Auto Shrink deletes any transactions, which transactions are deleted?
What happens to the tlog when Truncate Log on CheckPoint is selected (which transactions are marked inactive or removed)?
What is meant by inactive transactions (one month old, two months old,.........)?
If Truncate Log on CheckPoint is turned on, and a transaction log backup is done, some of the transactions will be removed from the tlog and written to the tlog backup. Does this mean that these removed records will be inaccessible through the database until the backed up tlog is appended to the active tlog?
I have these settings:
1. Auto Shrink ON
2. Truncate Log on CheckPoint OFF
3. Daily Full TLog backup ON
4. Weekly Full DB backup ON
5. Delete TLog backup files older than 8 days
6. Delete DB backup files older than 8 days
Assuming there are no space issues, is this plan OK?