Unanswered: microsoft sql-dmo (ODBC SQL STATE: 42000)
SQL server 7
I was in process of migrating database from staging to development server.
when i tried to restore the .bak of staging in develpment
it gave me the below error
microsoft sql-dmo (ODBC SQL STATE: 42000)
The database you are attempting to restore was backed up under a different sort order ID (54) than the one currently running on this server(52), and at least one of them is a non-binary sort order
Backup or restore operation terminating abnormally.