Q:    How to attach console backup if the ‘Data Error’ message appear?

A:    In most cases, the message appeared because the sorting order of that console backup is different from that of the SQL server using now.

2 SQL command files will be used in the steps below:

(1)deleteIndexes.sql (Please change the file extension from .txt into .sql after downloaded)

(2)AlterTableColumn_Collate.sql (Please change the file extension from .txt into .sql after downloaded)

Steps:

  1. In the SQL Server Management Studio, Select the ‘Database’ folder and click Attach…
Browse and Go to the physical location for the backup, then Add and Attach the database.



  1. In the SQL Server Management Studio, select the attached backup database from the left (below use OCULAR3_20100201_20100228 as an example).
And then open the (1)deleteIndexes.sql and press the !Execute button.



  1. After the SQL command execution finished, close that SQL file, and again select the attached backup database from the left (below use OCULAR3_20100201_20100228 as an example).
Now open the (2)AlterTableColumn_Collate.sql and press the !Execute button.



  1. After the second SQL execution finished, you can see XXX row(s) affected in the result.
  2. Then you can re-start the SQL server database service. Then IP-guard service also needed to be started.
  3. Login Console and review the backup as usual.
Go to top