<div>
<div class="content wysiwyg-content">
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
</div>
</div>


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

SQL 2000 Version conflict when restoring database backup

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.