Discussion Locked

Database restore with different characte

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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...

5 replies

by msullivan

You have to install a new SQL server. Be sure to select the Code Page, Character Set, Sort order and Unicode you need.

Your code page is 1252, sort order is "nocase_iso".

Your locale ID is "general unicode"

I'm not sure about the value foryour Unicode comparison style, but I think it may be a default.

Once you have installed the new SQL Server with these parameters, you should be able to restore your database.

Mike Sullivan
MCSE+I, MCDBA, MCT

by sasha.memedovic

Shut down all SQL apps/services on the local server
Insert SQL7 CD into drive
Go to C:\MSSQL7\BINN\Rebuildm.exe - double click on it to start "Rebuild Master box"
Click browse and select x86\data directory from the CD
Click "Settings" and pick:196611(character Set)
52(sort order)
1033(local identifier)
All other boxes UNSELECTED
Click OK and then Rebuild
Restart SQL Server on local server

This discussion is closed to new replies.