Greetings all,
I'm sorry, but this is going to be a long post. We run a program called Pivotal as our CRM system. It used SQL 2K enterprise as it's back end, and I do have it clustered. I have setup replication of the databases to our DR site, and all was working well. A few weeks ago, we had a major problem with the database, a result of the CRM app. I ended up doing a SQL dump of an identical database and then restoring it to our production system. Doing this worked, for all intensive purposes. The one thing that did not work was replication. We replicate 3 databases, and I was able to stop replication on 2 of them. The third is getting the following errors:
"Error 208: Invalid object name 'sysarticles'"
"Invalid object name 'sysschemaarticles"
"Could not use view or function 'sysentendedarticlesview' because of binding errors"
Does anyone have any ideas. Any help would be greatly appreciated.
Thanks,
Dave
I'm sorry, but this is going to be a long post. We run a program called Pivotal as our CRM system. It used SQL 2K enterprise as it's back end, and I do have it clustered. I have setup replication of the databases to our DR site, and all was working well. A few weeks ago, we had a major problem with the database, a result of the CRM app. I ended up doing a SQL dump of an identical database and then restoring it to our production system. Doing this worked, for all intensive purposes. The one thing that did not work was replication. We replicate 3 databases, and I was able to stop replication on 2 of them. The third is getting the following errors:
"Error 208: Invalid object name 'sysarticles'"
"Invalid object name 'sysschemaarticles"
"Could not use view or function 'sysentendedarticlesview' because of binding errors"
Does anyone have any ideas. Any help would be greatly appreciated.
Thanks,
Dave
