No results found. You can ask us instead.
No results found. You can ask us instead.
Phone Lines icon GFI Support Home Sign in
No results found. You can ask us instead.
Start a conversation
  1. GFI Support
  2. GFI Support - Archiver Section
  3. Articles

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

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.
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. Priyanka Bhotika

  2. Posted 7 days ago

Comments