General discussion

  • Creator
    Topic
  • #2082144

    Database restore with different characte

    Locked

    by jba ·

    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…

All Comments

  • Author
    Replies
    • #3901592

      Database restore with different characte

      by msullivan ·

      In reply to Database restore with different characte

      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

    • #3872641

      Database restore with different characte

      by sasha.memedovic ·

      In reply to Database restore with different characte

      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

    • #3874247

      Database restore with different characte

      by jba ·

      In reply to Database restore with different characte

      This question was auto closed due to inactivity

Viewing 2 reply threads