question

Rahul 2 avatar image
Rahul 2 asked

Sql Server 2005 Replication

Dear Experts,

I am facing a serious problem in Sql Server 2005 replication. I have done a merge replication in SQL Server 2005 for 2 subscribers with separate publications.

The problem actually arises from the second day of replication which causes the replication jobs are being never executed completely. This happens every morning and thus the data are not getting updated in the publisher.

Also, there are other users which are directly connected to the publisher for whom the entries are not getting saved because of this problem in the replication. When I just restarted the sql server database service it came to the normal stage and it will work smoothly for that day. But next day morning , the same thing will happen which i have to go there and restart the service again to make it under control.

The funny thing here is there was no problem at all when the replication was in SQL Server 2000.

I just upgraded the SQL Sever to increase the performance and to make available of new features like analysis service and reporting service. I also installed service pack 3 of SQL Server 2005.

Please suggest me an appropriate solution for this.

Thanks and Regards

Rahul Krishnan R

replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
brandonvmoore avatar image
brandonvmoore answered

Rahul,

Have you taken a look at the replication monitor?

You said the reason you upgraded to 2005 was primarily to take advantage of the reporting and analytical features. You could always create a second instance of sql, copy the data to a db on that instance (ie. use replication or dts), and then use the features you're wanting on that second database. The benefit of this is that a) you could return to sql 2000 on your primary instance so that the replication would work properly and b) you could run the second instance on a seperate machine so that use of these features wouldn't bog down the main server.

Obviously that's not the ideal solution, but I thought I would mention it just in case a better solution doesn't present itself in a timely fashion.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.