SQL Server 2012错误 [英] SQL Server 2012 error

问题描述

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: http://go.microsoft.com/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: http://go.microsoft.com/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.com/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: http://msdn.microsoft.com/en-us/library/ms188664.aspx[^]

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