Database restore with different characte - TechRepublic
General discussion
March 23, 2000 at 07:11 PM
jba

Database restore with different characte

by jba . Updated 25 years, 7 months ago

I’m trying to restore a database which was backed up in a different Character Set, Sort Order and Unicode collation and of course I get an error message stating that SQL Server cannot restore the DB.

Can someone tell me how must I setup SQL Server Character Set, Sort Order and Unicode collation during Setup or using the RebuildM utility to have a Unicode locale id of 1033, a Unicode comparison style or 196611 and a sort order of 52? Thanks in advance…

This discussion is locked

All Comments