Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

idiom

Status
Not open for further replies.
jotita

jotita

Programmer
Aug 19, 2002
19
AR
I need restore a backup of another server.
When I do this, a message display: id 54 and sql in 52...
and no restored.!
sorry my english...
 
Sort by date Sort by votes
Please post the whole error message. Also look in Windows Event Viewer logs (application and system) to see if there are any error messages that apply to this. Check the SQL Server Error Logs for messages.

How are you doing the restore? What commands are you using?

-SQLBill


Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Microsoft SQL-DMO (ODBC SQLSTATE: 42000)

The backup taht you want to restore have an ID of sort (54) and the DB has 52, and use index NO binary.


 
Upvote 0 Downvote
Which version of SQL Server are you using?

And how are you doing the restore?

-SQLBill
 
Upvote 0 Downvote
Nevermind....this deals with the SQL Collation settings. Refer to BOL for more information on SQL Collations.

Basically, you have a database from ServerA that you are trying to restore to ServerB. ServerA's collation is different from ServerB.

ServerA = 54. Dictionary order, case-insensitive, accent-insensitive, use with 1252 character set.

ServerB = 52. Dictionary order, case-insensitive, use with 1252 character set.

The difference between the two is how it handles accents.

You need to change the SQL Collation on ServerB to 54.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top