Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have setup a SQL 2005 database replication (transactional) between two servers. I have noticed today that the non-clustered indexes do not seem to have gone across to the replicated database.

I have had a look round sql management studio and cant find anything to create a script for them on mass (there are 100's of tables), and i also cant see anything in the replication options to send them across.

Is there an easy way to copy them across, or include them in the initial snapshot at least as a last case i can re-create the snapshot?

Cheers Luke

share|improve this question
up vote 0 down vote accepted

You will need to script the indexes and run it in the replicated database. The script that I use to do that, you can find it here

share|improve this answer
looks what i'm after, thanks – beakersoft Sep 15 '11 at 10:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.