| 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? |
 |
|
|
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? |
|
|
|
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... |
|
|
|
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? |
|
|
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 00:33:08
|
| Or rebuild master db with that sort order. |
|
|
|
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.???GreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
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.???GreetingsWebfredThere 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? |
|
|
|
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.GreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
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. |
|
|
|
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. |
|
|
|
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 |
|
|
|
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??? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-06-16 : 21:52:28
|
| read the solutions above. also this link |
|
|
|
Randall2146
Starting Member
2 Posts |
Posted - 2014-07-02 : 07:25:19
|
| how can i update my MSSQL 6.5 to 7.0 ? |
|
|
|
|
MSSQL 7.0 restore file error due to sort order