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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2007-08-06 : 09:52:10
|
| We ahev to rebuild our indexes every night to keep an application running ok. Is there any danger in doing this so often? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-06 : 09:57:33
|
| no not really... but it depends on your procedure.what kind of danger are you thinking of?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2007-08-06 : 10:00:48
|
| I dunno just didn't know if it was a bad idea to reindex so often. One side effect I have noticed is 20 gig used in the log file each reindex meaning a very large file is shipped after the reindex. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-06 : 10:02:39
|
| shipped where?index defrag is good. it will also take all the space it needs._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2007-08-06 : 10:04:48
|
| log shipped to another server. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-08-06 : 10:07:35
|
| http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx |
|
|
|
|
|
|
Index Rebuild