Restoring a database from one server to a new one

[kim]

Im trying to restore database x from server 1 to database y on server 2.

Im having problems doing so.

I took a backup of database x called 'bkup'.

I then moved bkup from server 1 c:\ drive to server 2 c:\ drive.

But when using EM, the restore function wont let me do so and giving me the error msg:
The dbase you are trying to restore was backed up using a "different unicode locale ID" or comparison style.

Both servers are SQL 7....any idea ?

thanks

[Mike John]

The unicode collation options were set differently on the two servers when SQL server was installed. On 2000 one server can handle different collations for different databases, but with 7 they must all be the same. Options you have are Uninstall and reinstall SQL server on the new box with same sort order, character set and unicode configuration as the first system (assumes you have no db you want on new server) or move up to 2000. If I remeber right sp_helpsort will give you the current configuration details.

Mike John

[rmiao]

Since you use sql7, have to rebuild master db on server 2 with same unicode locale ID as on server 1.

[kim]

thanks guys !