Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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

http://www.sqlservercentral.com/Forums/Topic401795-566-2.aspx

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

Your Answer

 
discard

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.