Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a long story that I will condense to a few bullet points that leads up to my question

  • Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
  • Reporting Server was migrated to new SAN
  • Reporting Server fatally crashed upon completion of migration (model db was corrupted)
  • I installed another instance of SQL on a node of the cluster, attached dbs, and changed report connections to use this new instance
  • Stupidly, I attached the [distribution] database to this new instance
  • select * from sysservers (rightly) returns that the distributor is still the first instance on the cluster.

My question is this. How terribly would it break things if I ran the following on the publisher (or is this even possible):

sp_configure ‘allow updates’, 1
 GO
 RECONFIGURE WITH OVERRIDE
 GO

update sysservers set datasource = 'server\instance' where srvname = 'repl_distributor';
GO

sp_configure ‘allow updates’, 0
 GO
 RECONFIGURE WITH OVERRIDE
 GO

EDIT:

Is this even the best way, or is there an alternative way to change the distributor?

share|improve this question
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.