Microsoft SQL Server 2012 附加数据库
今天闲来无事想看看以前的一个老旧的数据库，用Microsoft SQL Server 2012 附加数据库，结果悲剧了，出了一堆的错误，所幸经过几次尝试后终于解决了问题，错误信息如下，解决的方法也简单，以管理员身份运行SQL Server Management Studio，然后再附加数据库即可，写出来供大家参考。TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'SERVER01'.(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&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)
------------------------------
Unable to open the physical file "G:\Database\EAS\Develop\EAS_Data.MDF". Operating system error 5: "5(拒绝访问。)". (Microsoft SQL Server, Error: 5120)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3153&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
页:
[1]