The database you are attempting to restore was backed up under a different Unicode locale ID (%d) or Unicode comparison style (%d) than the Unicode locale ID (%d) or Unicode comparison style (%d) currently running on this server.
This error occurs when attempting to restore a database with a different sort order from that of the backed up database. This error occurs when using any sort order except binary sort order.
A database cannot be restored using RESTORE DATABASE unless these items match between the database and the server:
Important Microsoft® SQL Server™ does not support concurrent mixed sort orders. Only the same sort order can be used by both the server and data to be imported or restored.
Change the mismatched items to be the same. For more information, see Changing the Character Set, Sort Order, or Unicode Collation.
For example, if the database uses sort order x and the backup to load uses sort order y, then use either bcp, BULK INSERT, or Data Transformation Services (DTS) to save the database in the x sort order. Then, reinstall SQL Server. After reinstalling SQL Server, load the database with the y sort order. Finally, either bcp, BULK INSERT, or DTS to restore the data with the x sort order.
Backing Up and Restoring Databases | Error 3120 |
bcp Utility | Overview of Installing SQL Server |
BULK INSERT | RESTORE |
Errors 3000-3999 | Sort Order |