Dear Team. I have a doubt while implementing the Replication concept in Production environment. Actually we have three Database server for replication for dedicatedly Publisher , distributor and Subscriber. During the up gradation process from SQL Server 2000 to SQL Server 2005 we have upgraded the database SQL 2005 in distributor and Subscriber Servers with compatibility level 90. But our Publisher Server is in SQL 2005 with compatibility level of 80.now we are planning to change compatibility level from 80 to 90 in publisher end. Could someone help me to done this: 1. Whether we can change the compatibility level from 80 to 90 without disturbing Replication configuration?2. Are We need to drop the configuration while changing the compatibility level from 80 to 90 ,. Please update your concerns to proceed further.
Here are some documents to refer, http://msdn.microsoft.com/en-us/library/ms143241.aspx, http://sqlserverpedia.com/blog/sql-...errors-caused-by-compatibility-level-setting/, http://kendalvandyke.blogspot.com/2009/07/replication-snapshot-errors-caused-by.html and http://msdn.microsoft.com/zh-cn/library/ms146875(SQL.90).aspx I have personally never did this hence could not comment on whether this could be done or not, will revert to you once I test on my machine.
Hi Hemant. Thanks alot for your kind update on this. did you get any chance to expore more on this issue. i was thinking that if we can stop the replication agent and te change the compatability and then start replication agent, but still i am thinking what would be the better oprion.