January 20, 2013 at 7:51 pm
Is it fine if we change compatibility level of a Database which is in Logshipping from 80 to 90 in Sql server 2005 as i am getting below error while index rebuilding.
"ALTER INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The Database is in Sql server 2005 but its compatibilty is 80 instead of 90.
Will it affect the logshipping if we change the compatibilty level
January 20, 2013 at 8:46 pm
I have tried its working fine.
January 22, 2013 at 3:44 am
Log-shipping will work fine after the change. But have you checked the application connecting the database. Compatibility 80 means SQL 2000 and 90 means sql 2005.
Regards
Dhananjay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply