如何解决附加数据库的错误948 [英] how to solve error 948 of attaching database
问题描述
TITLE：Microsoft SQL Server Management Studio
------------------------------
服务器'ABHINAV-PC'附加数据库失败。 （Microsoft.SqlServer.Smo）
如需帮助，请单击：http：//go.microsoft.com/fwlink？ProdName = Microsoft + SQL + Server&ProdVer = 10.50。 4000.0 +（（KJ_PCU_Main）.120628-0827 +）&EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID = Attach + database + Server&LinkId = 20476
- -----------------------------
附加信息：
执行Transact-SQL语句或批处理时发生异常。 （Microsoft.SqlServer.ConnectionInfo）
--------------------------- ---
无法打开数据库'timtableso'，因为它是版本655.此服务器支持版本611及更早版本。不支持降级路径。
无法打开新数据库'timtableso'。 CREATE DATABASE被中止。 （Microsoft SQL Server，错误：948）
如需帮助，请单击：http：//go.microsoft.com/fwlink？ProdName = Microsoft + SQL + Server&EvtSrc = MSSQLServer&EvtID = 948&LinkId = 20476
----------------------------- -
按钮：
OK
-------------- ----------------
每次我试图附加数据库时都会显示此错误。
和这个数据库是在sql server 2008中创建的，我也在使用sql server 2008，但它仍然是一个错误。
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'ABHINAV-PC'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'timtableso' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'timtableso'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
This error is shown every time when i'm trying to attach a database.
and this database is created in sql server 2008 and i'm also using sql server 2008,still it is giving an error.
推荐答案
看来你的数据库是用SQL创建的Server 2008，但您尝试将其附加到SQL Server的实际版本是SQL Server 2005（请参阅内部SQL Server数据库版本号 [ ^ ]）。
显示的帮助链接可能会使用SQL Server Man agement Studio 2008 R2（10.50）;您确定要将数据库附加到的实例也是SQL Server 2008 R2吗？因为错误消息指出此实例是SQL Server 2005实例。
It seems your database has been created with SQL Server 2008, but the actual version of SQL Server you are trying to attach it to is SQL Server 2005 (see Internal SQL Server Database Version Numbers[^]).
The help link shows to you may use SQL Server Management Studio 2008 R2 (10.50); are you sure that the instance you are trying to attach your database to is also a SQL Server 2008 R2 one? Because the error message states this instance is a SQL Server 2005 one.
这篇关于如何解决附加数据库的错误948的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
