在Ms Sql 2008中附加先前版本数据库 [英] Attaching Previous Version database in Ms Sql 2008

问题描述

我在Ms Sql 2008中附加Ms Sql 2000数据库文件它给出了错误

错误No 950

< br $> b $ b

Hi,
I am attaching Ms Sql 2000 database file in Ms Sql 2008 it is giving an error
Error No 950

Database 'MyDatabase' cannot be upgraded because its non-release version (515) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.

Could not open new database 'MyDatabase'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)

请帮助我在Mssql 2008中附加我以前的数据库

Pls help to attach my Previous database in Mssql 2008

推荐答案

阅读：http://www.sqlservercentral.com/Forums/Topic989262-391-1.aspx [ ^ ]

您无法直接附加使用SQL Server 2008数据库的SQL Server 2000数据库，首先需要在升级后将其与新版本（即SQL Server 2005）相连，将其与SQL Server 2005分离并使用SQL Server 2008重新附加。

You cannot Directly attach your SQL Server 2000 database with SQL Server 2008 database, first you need to attach it with its newer version(i.e SQL Server 2005) after up-gradation, detach it from SQL Server 2005 and reattach it with SQL Server 2008.

这篇关于在Ms Sql 2008中附加先前版本数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！