The database you are attempting to restore was backed up under a different sort order ID (%d) than the one currently running on this server (%d), and at least one of them is a non-binary sort order.
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 into Microsoft® SQL Server™ using RESTORE DATABASE unless these items match between the database and the server:
Important 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, use either bcp, BULK INSERT, or DTS to restore the data with the x sort order.
| Backing Up and Restoring Databases | Error 3149 |
| bcp Utility | Overview of Installing SQL Server |
| BULK INSERT | RESTORE |
| Errors 3000-3999 | Sort Order |