Post reply

Index Tuning Wizard and Transactional Replication

  • August 11, 2004 at 7:53 am

    #102154

    Good Morning!

    Running the Index Tuning Wizard against a database that is the Publisher in a Transactional Replication, returns, “An error occurred trying to execute a SQL statement,” when analyzing the database and the workload.

    Running the same statement against a Subscriber or a database that is not being used for replication, the Wizard runs without any issue.

    The Publisher is located in a different Server (but in the same machine) from the Subscriber and the isolated database and the error occurs for any statement.

    No other issue had been reported in the Publisher database, which is used in our production environment.

    Any thoughts, recommendations, lectures, or articles will be great appreciated.

    Thanks

  • August 16, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 16, 2004 at 11:12 am

    #519188

    Interesting. I know the wizard adds/drops indexes as it schemes along, just doing that shouldnt affect replication - unless it tries to change the primary key, that would not work and would break replication if it succeeded.

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply