Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2002-12-23 : 05:26:11
|
| I am using SQL server 7. I have created a backup of MyDB on the IT_DEV server which I want to restore it on DTC3 server. When I am trying to restore it through EM it gives me the following error :"The Database you are trying to restore was backed up under differect sort order ID (52) than the one currently running on the server ID(146) and atleast one of them is non-binary.Backup or restore operation terminating abnormally. "Can anybody suggest me how to restore this db on DTC3 server.Thanx.Marjo. |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-12-23 : 08:15:56
|
Marjo, in order to restore your db you need to have the same sort order on your target server.With SQL Server 7 you need to rebuild the master database with rebuildm.exe utility.Please read on BOL the details.From BOL:Before running the Rebuild Master utility, make sure you have the scripts to rebuild the database objects and a backup to reload the data. Rebuilding the master database removes all database objects and data. After rebuilding the master database, re-create the database objects and reload the data. Cheers.Franco |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2002-12-23 : 09:26:18
|
quote:
With SQL Server 7 you need to rebuild the master database with rebuildm.exe utility.
I guess this is what you must do as an absolutely last resort! Moving databases between servers is a complicated (but not uncommon) problem when the source and the target server have different collations. rebuildm might solve the problem for this instance, but you can imagine doing this every time you have to restore a database with a different sort-order. I think one solution to this problem is the following1. Manually create an empty database on DTC32. Then generate a script to create all the objects (including tables, views, keys, constraints, stored procs) from the source DB on IT_DEV3. Run this script on the new database on DTC3Another solution would be run the Import/export using the wizard or a DTS Package.But beware, if you have data in the database which is in a different language that is not supported by the target server collation, it will show up as wierd characters, particularly varchar fields.Hope this helpsOS======================================================I started out with nothing. Still have most of it left. |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-12-24 : 04:51:01
|
| Thanx a lot guys, As I am not a DBA I would prefer not not use rebuildm utility. Bcoz as suggested by you that rebuild utility removes all the database objects from the master db, I don't want to take any risks. I have transfered the db to DTC3 server using import / export DTS package. But for this I had to first create the db on DTC3 and then transfer the DB objects from IT_DEV. Anyway my work is done. But can you please explain me, what this SORT ORDER ID is ?And thanx a lot once again for your assistance. I will read about rebuildm utility and find out more about it.Bye.Best Regards,Marjo. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-12-24 : 04:59:25
|
| A "SORT ORDER" is the official way of dealing with non-standard character sets (ie anything not-english)SWEDISH, NORWEGIAN, DANISH, CHINESE, etc character sets have extra letters that don't appear in the English alphabet (ie...characters with umlats and other pronunciation aids). There then is an issue when people, using those character sets, want to sort name alphabetically....ie for a phone book....the sort order basically enables the users to places these characters into a sensible order.Different character sets have different "sort orders" because while English has 26 letters in its alphabet, SWEDISH, NORWEGIAN, DANISH, CHINESE, etc would have 26+ and the extra characters aren't always in the same place....You'll find more information on this topic in Books-On-Line. |
|
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2002-12-24 : 05:04:54
|
| OkThanx AndrewMurphy. |
|
|
|
|
|
|
|
|
Sort Order ID(52) Error while Restoring DB