https://community.hpe.com/t5/backoffice-products/sql-restore-database-error/m-p/2946009#M1365 Heres a good article from MS the walks through the processes of restoring or moving database.<BR /><BR /><A href="http://support.microsoft.com/default.aspx?scid=kb;en-us;314546" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;314546</A><BR /><BR />Jon Tue, 08 Apr 2003 14:41:59 GMT Jon Finley 2003-04-08T14:41:59Z https://community.hpe.com/t5/backoffice-products/sql-restore-database-error/m-p/2946008#M1364 I am attempting to restore a database from an old server running SQL server 7.0 to a new server running the same. I am getting a error stating that the database was backed up under a different sort id (49) then is currently running (52) and it will not restore. I know that this is a problem when installing SQL server and the options for setup. I have tried many combinations and can not get to (49), I have found (30) (40) (50) (51) and (52) but not (49). Can you let me know the proper setting in setting up Sql<BR /> Tue, 08 Apr 2003 11:29:57 GMT https://community.hpe.com/t5/backoffice-products/sql-restore-database-error/m-p/2946008#M1364 Steven Miller_4 2003-04-08T11:29:57Z https://community.hpe.com/t5/backoffice-products/sql-restore-database-error/m-p/2946009#M1365 Heres a good article from MS the walks through the processes of restoring or moving database.<BR /><BR /><A href="http://support.microsoft.com/default.aspx?scid=kb;en-us;314546" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;314546</A><BR /><BR />Jon Tue, 08 Apr 2003 14:41:59 GMT https://community.hpe.com/t5/backoffice-products/sql-restore-database-error/m-p/2946009#M1365 Jon Finley 2003-04-08T14:41:59Z