Error 3120

Severity Level 16

Message Text

The database you are attempting to LOAD was DUMPed 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.

Explanation

This error occurs when you try to load a database that has a different sort order from that of the dumped database. Data does not have to be sorted in binary order.

A database cannot be loaded into SQL Server using LOAD DATABASE unless the sort order on the SQL Server that dumped the database matches the sort order on the SQL Server being loaded into.

Action

You can either move the data (using bcp rather than LOAD), or you can change the sort order on the SQL Server.

You can use the setup program to update your existing installation and rebuild the master database, but you must still rebuild all other databases yourself. For additional information, see Microsoft SQL Server Setup and Chapter 3, "Configuring Servers."