SQL 7 database restore

[riches85]

I was given an application that runs on sql 7 and was asked to set it up at work. When I go to resore the database that is given to me i get this crazy error. I am still kinda new to Microsoft SQL 7 so I'm sure it is something simple. The error reads:

" The database you are attempting to restore was backed up under a different unicode locale (1033) or unicode comparison style (196609) than the unicode locale ID (1033) or unicode comparison code style (19661) Currently running on the server. Backup or restore operation terminating abnormally. "

It restored fine when i tried it on my XP machine, but when i went to restore it onto the server I get this error. Does it have anything to do with the fact that it worked on a machine running fat32 and not on the server which is running NTFS? If so, are there any work arounds? Any help would be greatly appreciated. Thanks

 

[jester777]

When you install SQL you define which character set to use, which sort order to use and whether case sensitivity is important.
When you backup a database it has to be restored to a server running the same settings. In your case I would say your XP machine happens to have the same settings as your original machine, but unfortunately your server has different settings.
The application you need to run may also depend on having the same settings.

Look at "Copying Databases Between Different Code Pages and Sort Orders" in books online. It basically states you will have to reinstall SQL (you may get away with rebuilding the SQL master database). The only alternative would be to create an identical empty database on your server, bcp all the data off your XP restored db and import that into the empty database on your server. This is time consuming and depends if the application can run with these different settings.