Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schuhtl
Posting Yak Master
102 Posts |
 Posted - 2005-07-28 : 11:31:20
|
| I was curious how other dba's manage defraging indexes and how to keep the transaction log at a reasonable size (whithout shrinking). In the past I have always done something like the following but I am not sure if there is a better way. Any suggestions?backup tlogSet Recovery BULK_LOGGEDDBCC DBREINDEXSet Recovery FULLFull DB backup |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-28 : 13:12:30
|
| that seems reasonable. check Tara's blog, she has some entries regarding dbreindex, and some scripts to automate.-ec |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-28 : 13:24:11
|
| What risk is there to the abiliy to rollback during the DBCC DBREINDEX? That job takes a while here - more than the interval between transaction backups. (Maybe you are able to run yours in a maintenance window)We use the DBCC command for DEFRAG, rather than REINDEX, on "large" indexes.Kristen |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2005-07-28 : 13:49:02
|
| eyechart - I implemented Tara's dbreindex script about 6 months ago...if Tara reads this Thank You Tara!Kristen - On all of my db's I have an unofficial maintenance window (no users accessing the systems) over the weekend in which I can afford to due a dbreinex. |
|
|
|
|
|
|
dbreindex and tlog size "best practice"