October 1, 2003 at 7:43 am
Has anyone seen this before?
I am attempting to restore a SQL 7 database backup that I recieved from a vendor. It is a backup of one of our databases that we sent to them, they made changes too and then sent back to us.
On restore I got the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Error 3169: The backed-up database has on-disk structure version 539. The server supports version 515 and cannot restore or upgrade this database. Backup or restore terminating abnormally.
I seem to be having problems with the Microsoft Knowledgebase website. When I submit a query it just hangs and hangs (20 minutes so far). Any help from y'all would be greatly appreaciated.
Thanks!
October 1, 2003 at 9:46 am
Finally heard back from the vendor and found out that they had restored the copy of our database to a SQL Server 2000 instance and applied their upgrades. The backup they sent us was from a SQL Server 2000 Sp2 database and thus will not restore to our SQL 7 instance.
Thanks anyway!
October 1, 2003 at 11:43 am
RESTORE HEADERONLY command will tell you information about your backup file such as database version, CompatibilityLevel etc. Check BOL for details.
October 1, 2003 at 11:47 am
Excellent, I wasn't aware of that one. Thanks for the tip, Allen. That is one handy command.
October 1, 2003 at 12:00 pm
quote:
Finally heard back from the vendor and found out that they had restored the copy of our database to a SQL Server 2000 instance and applied their upgrades. The backup they sent us was from a SQL Server 2000 Sp2 database and thus will not restore to our SQL 7 instance.Thanks anyway!
How nice of them. Upgrade without your permission/knowledge and make it un-useable UNLESS you pay to upgrade.
-SQLBill
October 21, 2003 at 9:36 am
Is it possible to restore SQL2K backup into SQL7 server and vice versa?
Or the only choice is DTS?
October 21, 2003 at 10:56 am
korotky,
You can not restore a SQL2000 database onto a SQL7 server.
You can restore a SQL7 database onto a SQL2000 server.
SQL2000 is backwards compatible with SQL7, but SQL7 is not forwards compatible.
-SQLBill
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply