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 |
|
tomfloate
Starting Member
1 Post |
 Posted - 2004-08-10 : 07:00:57
|
| Hi All I am doing the following command ...RESTORE DATABASE RebusFROM DISK = 'C:\Temp\Rebus.BAK'WITH REPLACEAnd I am getting the following error ...Server: Msg 3149, Level 16, State 1, Line 1The database you are attempting to restore was backed up under a different Unicode locale ID (33280) or Unicode comparison style (0) than the Unicode locale ID (1033) or Unicode comparison style (196609) currently running on this server.any ideas about how to get around this? |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-10 : 11:39:19
|
| Several ways, but not sure any of them are appropriate....1) Reinstall SQL on the server you are moving this to so it has the Unicode Locale ID and/or style you need. This will make any user databases on that server now unusable, though.2) Convert the database you are moving to the new Locale ID/Style by scripting all your tables, creating a new empty DB on your target server, and then using DTS or BCP to import all of your data. If you do this, don't forget to script all your stored procedures and other objects as well. And don't create indexes on your tables until after the data is imported.3) Upgrade the target server to SQL 2000, it allows different databases to have different collations. But this can be VERY VERY messy, and I wouldn't recommend it unless you are a masochist. |
 |
|
|
|
|
|
SQL Server Restore Error