SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 MSSQL 7.0 restore file error due to sort order
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chixman
Starting Member

5 Posts

Posted - 07/03/2008 :  11:38:20  Show Profile  Reply with Quote
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!

Edited by - tkizer on 07/04/2008 11:56:25

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 07/03/2008 :  11:41:49  Show Profile  Reply with Quote
Are you sure its SQL server backup file?
Go to Top of Page

chixman
Starting Member

5 Posts

Posted - 07/03/2008 :  11:45:32  Show Profile  Reply with Quote
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 - 07/03/2008 :  12:12:23  Show Profile  Reply with Quote
does anybody know the answer to my problem? please... i need to fix this problem...
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

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

tkizer
Almighty SQL Goddess

USA
35937 Posts

Posted - 07/03/2008 :  15:52:25  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

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

webfred
Flowing Fount of Yak Knowledge

Germany
8679 Posts

Posted - 07/04/2008 :  02:37:23  Show Profile  Visit webfred's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 07/04/2008 :  13:51:46  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8679 Posts

Posted - 07/05/2008 :  10:05:22  Show Profile  Visit webfred's Homepage  Reply with Quote
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

USA
35937 Posts

Posted - 07/06/2008 :  00:34:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 07/11/2008 :  15:12:27  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/11/2008 :  22:24:32  Show Profile  Reply with Quote
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

USA
676 Posts

Posted - 07/14/2008 :  12:01:08  Show Profile  Reply with Quote
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

Sudan
1 Posts

Posted - 06/16/2013 :  02:59:22  Show Profile  Reply with Quote
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

USA
5071 Posts

Posted - 06/16/2013 :  21:52:28  Show Profile  Visit russell's Homepage  Reply with Quote
read the solutions above. also this link
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000