如何在Sql server管理中注意本地数据库 [英] how to attech Local db in Sql server management
本文介绍了如何在Sql server管理中注意本地数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在我的wpf apllication中,有localdb(.mdf和.ldf)
当我在vs 2012打开数据库然后它的工作完美
但是当我附加sql服务器管理工作室那么这样的错误
i尝试了很多解决方案,但没有人工作
>
in my wpf apllication, have localdb(.mdf and .ldf)
when i open database in vs 2012 then its work perfectly
but when i attached with sql server management studio then it's error like this
i tried many solution but no one worked
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MUKESH-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&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 'G:\WORKS\IQBAL SILKS\IQBAL SILKS\BIN\DEBUG\BILL_GENERATER.MDF' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
Could not open new database 'G:\WORKS\IQBAL SILKS\IQBAL SILKS\BIN\DEBUG\BILL_GENERATER.MDF'. 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
请帮忙......
please help...
推荐答案
错误信息非常明确 - 问题是什么 - 您已将数据库保存在比您的SSMS版本可以处理的更高版本中。
您已将问题标记为SQL-server-2008R2,但是您要从VS2012保存数据库 - M
The error message is quite clear on what the problem is - you have saved the database in a later version than your version of SSMS can handle.
You've tagged your question as SQL-server-2008R2 but you are saving the database from VS2012 - M
可以不要展望2008年的未来!基本上来自VS2012的LocalDb与早期版本不兼容。
我建议你升级你的sql server管理工作室版本 - 快递版是免费的来自M
could not look into the future in 2008! Essentially LocalDb from VS2012 is not compatible with earlier versions.
I suggest that you upgrade your version of sql server management studio - the express version is free from M
[ ^ ]
这篇关于如何在Sql server管理中注意本地数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文