SQL Server 2012错误

本文介绍了SQL Server 2012错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

hi 我有一个问题。我有数据库MS SQL 2005但我需要将mssql 2005数据库附加到mssql 2012服务器。我不能。请帮我怎么做。因为Mssql 2005数据库里面有很多数据。请帮助我如何做到这一点。 以下是错误

hi I have an issue. I have database MS SQL 2005 but I need to attach the mssql 2005 database into mssql 2012 server. I could not. please help me how to do this. Because Mssql 2005 database has lots of data inside. Pleas help me how to do so. Below is the error

TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SILS-PC'. (Microsoft.SqlServer.Smo) For help, click: go.microsoft/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&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 "D:\HCKCMS\database2012\CMSHCK.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120) For help, click: go.microsoft/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

推荐答案

请注意，如果将2005 DB附加到SQL2012，则无法将其与SQL一起使用2005年再次--Sql将其转换为最新格式，并且没有设施可以导出2005友好版本。 一个更好，更好的想法是复制数据库并允许2012版本成为它管理的新的独立数据库： http：// msdn。 microsoft/en-us/library/ms188664.aspx [ ^ ] Be aware that if you attach your 2005 DB to SQL2012 you will not be able to use it with SQL 2005 again - Sql will convert it to the latest format, and there is no facility to export a 2005 friendly version. A much, much better idea would be to copy the DB and allow the 2012 version to be a new, separate DB that it manages: msdn.microsoft/en-us/library/ms188664.aspx[^]