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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-07-01 : 07:06:31
|
| Hi all.I'm currently replicating a database to another site. I have question regarding the reindexing of these databases.I don't want to impact replication, as in I don't want it to stop.Is the best strategy to do an online rebuild when no one is really using the system? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-01 : 07:09:38
|
| Sounds like it should be ok.Make sure you don't add any new constraints that might cause an issue.Note - you should be able to do an on-line index (assuming enterprise+ version) while replication is running. It might slow things down but that should be all. Best to do it at quiet times though.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-07-01 : 12:27:58
|
| If I rebuild the index on the publisher, will the index be rebuilt on the subscriber?From what I understand, indexes are replicated across. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Reindexing replicated database