Error 3149

Severity Level 16
Message Text

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.

Explanation

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.


Action

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.

See Also
Backing Up and Restoring Databases Error 3120
bcp Utility Overview of Installing SQL Server
BULK INSERT RESTORE
Errors 3000-3999 Sort Order

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.