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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-11-09 : 16:07:52
|
| Hi Experts,I need a small suggestion about Index defragmentation as i got an issue about performance can we create a maintenance plan for defragmenting index or reindex on the database which are in logshipping.Thanking you all.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-11-09 : 17:07:38
|
| Thank you Tara Kizer,need one more small information on the same, can we create a maintenance plan for shrinking of database and update stats on the same databases which are in logshipping. |
 |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-20 : 13:23:08
|
| there will no impact of shrink and updatestats on logshiping databases. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-20 : 13:49:22
|
| Don't shrink!!!!!Shrinking databases regularly is about the worse possible practice. It creates massive fragmentation (which, since the shrink will be shipped to the secondary will also affect that)See - [url]http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
index defragmentation on loggshipping database