Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing compatibility Expand / Collapse
Author
Message
Posted Sunday, January 20, 2013 7:51 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:47 AM
Points: 81, Visits: 942
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
Post #1409337
Posted Sunday, January 20, 2013 8:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:47 AM
Points: 81, Visits: 942
I have tried its working fine.
Post #1409341
Posted Tuesday, January 22, 2013 3:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:45 AM
Points: 127, Visits: 307
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
Post #1409901
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse