rebuild index job on a replicated database

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.

All Forums

SQL Server 2008 Forums

Replication (2008)

rebuild index job on a replicated database

Author

Topic

AgaK
Yak Posting Veteran

86 Posts

Posted - 2010-11-29 : 13:56:51

Hi

Would a rebuild index job on a replicated database break the replication?

Thank you

AK

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-29 : 13:58:18

No. A replicated database (both the publisher and the subscriber) should have maintenance routines scheduled for performance reasons. The most critical one is update stats. Rebuilding indexes isn't as important unless the fragmentation is high and is known to be causing performance issues. Fragmentation is very rarely the culprit of performance issues.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources