Phone Lines icon GFI Support

Articles in this section

See more

Error: 'Failed during: Upgrading Schema Version Details: Query Failed' when attaching Microsoft SQL Server 2000 database

Author: Luis Fernandes

Answer

PROBLEM

Unable to attach a Microsoft SQL Server 2000 database. 

..\Store\DebugLogs\ManagementProviders.log shows the error:
 
"error ","ManagementProviders","Error: (MSSql) UpdateSchema. Rolling back 
;message: Invalid object name 'sys.columns'. 

or 

;message: Line 12: Incorrect syntax near '('. 

or

;message: Incorrect syntax near '@userHash'.
 

ENVIRONMENT

  • GFI MailArchiver 2012 or newer
  • Microsoft SQL Server 2000 

SOLUTION

Note that if the Microsoft SQL Server instance holding the data is actually running a newer version of Microsoft SQL Server, but the database's compatibility level is still on 80 or lower, raising it solves this issue. The version of the Microsoft SQL Server instance can be confirmed by running the following query against the instance using the Microsoft SQL Management Studio: SELECT @@VERSION

Please refer to Microsoft on details how to view or change the compatibility level: http://msdn.microsoft.com/en-gb/library/bb933794.aspx

CAUSE

As of GFI MailArchiver 2012, Microsoft SQL Server 2000 is no longer supported.