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.

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 MSSQL 7.0 restore file error due to sort order

Author  Topic 

chixman
Starting Member

5 Posts

Posted - 2008-07-03 : 11:38:20
hi! I am currently using MSSQL 7.0 Enterprise Manager and I cannot restore my back up file. I backed it up on another computer. An error occurred that says... "The database you are attempting to restore was backed up under a different sort order ID(52) than the one currently running on this server(146), and at least one of them is a non-binary sort order.
Backup or restore operation terminating abnormally."

How will I resolve this problem? i need the answer urgently... please reply... any one??? TY!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-03 : 11:41:49
Are you sure its SQL server backup file?
Go to Top of Page

chixman
Starting Member

5 Posts

Posted - 2008-07-03 : 11:45:32
yes it is... i backed it up in the office. i also used the same installer of mssql 7.0 enterprise in my laptop. it says sumthing about different sort order.. what is it?
Go to Top of Page

chixman
Starting Member

5 Posts

Posted - 2008-07-03 : 12:12:23
does anybody know the answer to my problem? please... i need to fix this problem...
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-03 : 12:44:08
Run checkdb on that database. Also can you post your restore script?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-03 : 15:52:25
You'll need to reinstall SQL Server using the same sort order as the source server. This was a major pain in SQL Server 6.5 and 7.0!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 00:33:08
Or rebuild master db with that sort order.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-04 : 02:37:23
This section is for any originally written scripts you'd like to share with the group.

???
Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-04 : 13:51:46
quote:
Originally posted by webfred

This section is for any originally written scripts you'd like to share with the group.

???
Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...



which script are you talking about? Are you talking about Script library?
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-05 : 10:05:22
Hi sodeep,
yes - i am talking about Script Library.
After i have posted this, this thread was moved to this new location.
Now everything is ok.

Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-06 : 00:34:22
I moved the thread after I saw it was in the wrong forum. You can tell by the edit in the first post.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

chixman
Starting Member

5 Posts

Posted - 2008-07-11 : 15:12:27
how do i configure the sort order id during installation? i didnt see any sort order id configuration in there.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-11 : 22:24:32
You choose how to sort like dictionary order, binary order, case sensitive, case insensitive and so.
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-07-14 : 12:01:08
If I remember SQL7 (it's been a while), during install, there is an "Advanced' button three or four screens into the process. Select that and it'll ask for collation/sort order. Select the appropriate one to match your original server.

Terry
Go to Top of Page

abdalla
Starting Member

1 Post

Posted - 2013-06-16 : 02:59:22
hi! I am currently using MSSQL 7.0 Enterprise Manager and I cannot restore my back up file. I backed it up on another computer. An error occurred that says... "The database you are attempting to restore was backed up under a different sort order ID(52) than the one currently running on this server(146), and at least one of them is a non-binary sort order.
Backup or restore operation terminating abnormally."

How will I resolve this problem? i need the answer urgently... please reply... any one???
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-06-16 : 21:52:28
read the solutions above. also this link
Go to Top of Page

Randall2146
Starting Member

2 Posts

Posted - 2014-07-02 : 07:25:19
how can i update my MSSQL 6.5 to 7.0 ?
Go to Top of Page
   

- Advertisement -