Solved

SQL 2000 Version conflict when restoring database backup

Posted on 2004-05-01
1
423 Views
Last Modified: 2007-12-19
I need to recover a SQL 2000 database. I have a backup of the database and of the master database. The original server was corrupt. I had to reinstall SQL. When I try to restore the databases, i get an error saying they cannot be recovered because the current version of SQL is different that the one the backup was made from. Both are SQL2000, but the backups were made under version 134217922. Does anyone know, or is there a way to find out exaclty which version or what patches were run to end up with version 134217922, or is there any way to get around this version issue to resore the databases? The version numbers are reported by Veritas Backup Exec
0
Comment
Question by:BJB137
1 Comment
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 10969467
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185&Product=sql2k

If you have your server at service pack 3a, the database should restore.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to share SSIS Package? 6 37
Help Required 3 97
Run SQL Server Proc from Access 11 31
Need help how to find where my error is in UFD 6 30
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question