August 11, 2004 at 7:53 am
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 11:12 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply