SQL Server 2008，附加数据库错误 [英] Sql Server 2008 , attaching data base error

问题描述

大家好，
我已经安装了vs 2010，并且在该sql server r2之后并尝试附加我的数据库
但是Sql Server抛出此异常

hi every one ,
i have install vs 2010 and after that sql server r2 and trying to attach my data base
but Sql server throw me this exception

The database ''XX'' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.<br />
Could not open new database ''XX''. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)<br />

我该如何解决此错误，以及为什么Management Studio会向我抛出此错误?
谢谢Advanced

how can i solve this error , and why Management studio throw me this error ?
thanks in advanced

推荐答案

你好

当您在该例行备份时使用的是哪个版本的sql? SQL允许将较低的版本迁移到较高版本，但是不允许将SQl从较高的版本迁移到较低版本.即使您必须检查Express，Web Server，Standard等版本，也可以将Express附加到Web Server上，甚至可以将Web Server转换为Standard或Express到Standard，但不允许反向操作

Hello

when you take backup at that tine which version of sql you were using?? SQL Allow to migrate lower version to higher, but SQl is not allow to migrate higher to lower. even you have to check edition like express, web server , standard etc. you can attach express to web server , even you can convert web server to standard or express to standard but you are not allow to do reverse

这篇关于SQL Server 2008，附加数据库错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！