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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-11-04 : 01:47:24
|
| I currently use Tara Kizer's script (thanks) for managing the indexes and it works great,my question is:We have a backup routine on our server for every database on it, within this backup routine is a step which Reorganizes the indexes, the workflow is:-Check Database Integrity (include indexes)Reorganize IndexesBackup Database (Full) - with overwrite existing.Shrink Database.Clean up History1. Would it be OK to remove the Index Reorganize part from our backup routines as this is managed via schedule (twice daily) via Tara's script?2. Would this speed up the backup routine? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-11-05 : 01:56:41
|
| Thanks Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Managing Indexes