HPE Community
BackOffice Products
1857362 Members
7576 Online
110372 Solutions
New Discussion

SQL restore database error

 
Steven Miller_4
Occasional Contributor

‎04-08-2003 04:29 AM

‎04-08-2003 04:29 AM

SQL restore database error

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
0 Kudos
1 REPLY 1
Jon Finley
Honored Contributor

‎04-08-2003 07:41 AM

‎04-08-2003 07:41 AM

Re: SQL restore database error

Heres a good article from MS the walks through the processes of restoring or moving database.

http://support.microsoft.com/default.aspx?scid=kb;en-us;314546

Jon
"Do or do not. There is no try!" - Yoda
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.