restore help

  • OUTMANG

    SSC Veteran

    Points: 231

    I am trying to do a database restore from a tape i get the following error is this recoverable?

    Error: the database you are attempting to restore was backed up under a different unicode locale id (1033)

    or unicode comparison style (196611) than the unicode locale id (1033) or unicode comparison style (196609)

    currently running on this server backup or restore operation terminating abnormally.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716326

    Is this SQL Server 7? The sort order and code page are different on the restore server. You set these when you install the server.

  • firthr

    SSCommitted

    Points: 1606

    you may have to rebuild them to be the same collation and stuff with rebuildm?

    Rob

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply