Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore won't restore if from a different sort order
Message
From
27/01/1999 15:39:36
 
 
To
27/01/1999 15:21:04
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00180994
Message ID:
00181013
Views:
16
>When attempting to restore a database, I have received this message:
>
>[Sql Server] The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (42), and at least one of them is non-binary sort order.
>
>Any idea on where to go to change this configuration?

Ok, what were they saying? If you can't find it in the SQL Server interface, then I should rebuild the master database. This is what I did. However, when you want to select the sort order, it gives you a list of sort orders. However, there is no match between an ID and the sort order list. How can we determine which sort order matches a specific ID?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform