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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-07 : 17:07:06
|
| Steve writes "I am trying to restore a database from my system which has the default unicode locale set to British onto another system that is also set to british. When i type select @@language on both machines it states that the databases are both british. However when i try to restore my database on the other machine it states that the Unicode Id is different and as a result wont restore the database. I have checked using exec sp_configure and on my machine the unicode Id is 1033 and on the other machine it is 2057. Yet on both everything is set to british how do i fix this.I need to restore my database on the other machine any help would be most appreciated" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-09 : 17:51:32
|
| Do an sp_helpsort on both servers. You will need to rebuild master on the server that it needs to be restored on, and the sort order and code page will have to be set to the same as the server it was backed up on.When you rebuild master, make sure you DTS or BCP the data out of any databases that you want to keep, then DTS or BCP it back in after you rebuildm, otherwise you will lose the data.HTH-Chad |
 |
|
|
|
|
|
Unicode ID