在sql server 2005中创建的db在sql server 2008中附加? [英] db created in sql server 2005 to Attach in sql server 2008?
问题描述
Hi
我在sqlserver 2005中创建了一个数据库。现在我想在sqlserver 2008中附加它。但我会面对错误:
无法检索此请求的数据。 (Microsoft.SqlServer.Management.Sdk.Sfc)
执行Transact-SQL语句或批处理时发生异常。
CREATE FILE在尝试打开或创建物理文件'F:\C#\ datad base \mydb.mdf'时遇到操作系统错误5(访问被拒绝。)。 (Microsoft SQL Server,错误:5123)
非常感谢
Hi
I created a database in sqlserver 2005 . now I wants to attach it in sqlserver 2008. But I would be face to error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch.
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'F:\C#\data base\mydb.mdf'. (Microsoft SQL Server, Error: 5123)
Thanks very much
推荐答案
https://www.packtpub.com/books/content/moving -database-sql-server-2005-sql-server-2008-三步 [ ^ ]
这篇关于在sql server 2005中创建的db在sql server 2008中附加?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!