restore help

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

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

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

    Rob

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

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