Restore databases under SQL 6.5

Hello,

I'm running SQL 6.5 on an old NT4 server. I built a new W2K server with SQL 6.5.

When I tried to restore a database to the new server I got the following error: "The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (32), and at least one of them is a non-binary sort order."
Since SQL 6.5 is no longer supported by Microsoft, I have a hard time finding information related to that error. Can someone help me and tell me what's wrong?

Regards,
Toan.The default sort order for MS-SQL 6.5 was 52. My guess is that you specified a different sort order, and that you can't restore the database unless you reinstall SQL 6.5 with the default sort order.

-PatP|||Pat,

Thanks for your help. I installed SQL 6.5 with the default settings. Where do you specify the sort order?|||It has been a LONG time since I've installed MS-SQL 6.5, but the sort order is specified somewhere very early in the installation process.

Have you considered using SQL 7.0 instead, and restoring the dump into a database there? It seems to me that you can restore a 6.5 dump onto a 7.0 server, and that they aren't nearly as finicky about sort orders.

-PatP|||You were right, the sort order ID has to be selected during the installation. Now I have to figure out which sort order was used on the old box.

Thanks Pat for your help.

Toan.|||52 is the default value, if that helps any.

-PatPsql

Restore backup problem

I'm using Sql 7.0 on a w2k machine. I'm trying to restore a DB from another
server using the following script:
Firsts created a v003 db. then applied:
RESTORE DATABASE v003
FROM DISK = 'C:\MSSQL7DATA\BACKUP\vehiculo_bak.003'
WITH MOVE 'V003_Data' TO 'c:\sql7data\data\V003_Data.MDF',
MOVE 'V003_Log' TO 'c:\sql7data\data\V003_Log.LDF'
but get :
Server: Msg 3234, Level 16, State 2, Line 8
File 'V003_Data' is not a database file for database 'v003'.
Server: Msg 3013, Level 16, State 1, Line 8
Backup or restore operation terminating abnormally.
Any help welcome.
RubénJust applied a small change to the code <replace>:
RESTORE DATABASE V003
FROM DISK = 'C:\MSSQL7DATA\BACKUP\vehiculo_bak.003'
WITH REPLACE, MOVE 'V003_Data' TO 'c:\sql7data\data\V003_Data.MDF',
MOVE 'V003_Log' TO 'c:\sql7data\data\V003_Log.LDF'
And get this message:
Server: Msg 3101, Level 16, State 2, Line 7
Database in use. The system administrator must have exclusive use of the
database to run the restore operation.
Server: Msg 3013, Level 16, State 1, Line 7
Backup or restore operation terminating abnormally.
Even thou I use: sp_dboption 'v003', 'dbo use only', 'true' command.
Any ideas welcome.
"Rubén Valenzuela" <rvalenzuela@.mapfreseguros.cl> wrote in message
news:%23DP%23hOORDHA.2144@.TK2MSFTNGP11.phx.gbl...
> I'm using Sql 7.0 on a w2k machine. I'm trying to restore a DB from
another
> server using the following script:
> Firsts created a v003 db. then applied:
> RESTORE DATABASE v003
> FROM DISK = 'C:\MSSQL7DATA\BACKUP\vehiculo_bak.003'
> WITH MOVE 'V003_Data' TO 'c:\sql7data\data\V003_Data.MDF',
> MOVE 'V003_Log' TO 'c:\sql7data\data\V003_Log.LDF'
> but get :
> Server: Msg 3234, Level 16, State 2, Line 8
> File 'V003_Data' is not a database file for database 'v003'.
> Server: Msg 3013, Level 16, State 1, Line 8
> Backup or restore operation terminating abnormally.
> Any help welcome.
> Rubén
>|||You still have a connection in the db. You can't have anything in there
other than the connection that is running the restore. Use sp_who2 to see
who is still in the db and close those connections. It's probably EM.
--
Andrew J. Kelly
SQL Server MVP
"Rubén Valenzuela" <rvalenzuela@.mapfreseguros.cl> wrote in message
news:OmsTcSORDHA.3880@.tk2msftngp13.phx.gbl...
> Just applied a small change to the code <replace>:
> RESTORE DATABASE V003
> FROM DISK = 'C:\MSSQL7DATA\BACKUP\vehiculo_bak.003'
> WITH REPLACE, MOVE 'V003_Data' TO 'c:\sql7data\data\V003_Data.MDF',
> MOVE 'V003_Log' TO 'c:\sql7data\data\V003_Log.LDF'
> And get this message:
> Server: Msg 3101, Level 16, State 2, Line 7
> Database in use. The system administrator must have exclusive use of the
> database to run the restore operation.
> Server: Msg 3013, Level 16, State 1, Line 7
> Backup or restore operation terminating abnormally.
> Even thou I use: sp_dboption 'v003', 'dbo use only', 'true' command.
> Any ideas welcome.
> "Rubén Valenzuela" <rvalenzuela@.mapfreseguros.cl> wrote in message
> news:%23DP%23hOORDHA.2144@.TK2MSFTNGP11.phx.gbl...
> > I'm using Sql 7.0 on a w2k machine. I'm trying to restore a DB from
> another
> > server using the following script:
> >
> > Firsts created a v003 db. then applied:
> >
> > RESTORE DATABASE v003
> > FROM DISK = 'C:\MSSQL7DATA\BACKUP\vehiculo_bak.003'
> > WITH MOVE 'V003_Data' TO 'c:\sql7data\data\V003_Data.MDF',
> > MOVE 'V003_Log' TO 'c:\sql7data\data\V003_Log.LDF'
> >
> > but get :
> >
> > Server: Msg 3234, Level 16, State 2, Line 8
> > File 'V003_Data' is not a database file for database 'v003'.
> > Server: Msg 3013, Level 16, State 1, Line 8
> > Backup or restore operation terminating abnormally.
> >
> > Any help welcome.
> >
> > Rubén
> >
> >
>