无法打开物理文件"D:understructuredata_DAT.MDF&
Jun 07, 2016 pm 04:10 PM错误信息: 标题: Microsoft SQL Server Management Studio------------------------------附加数据库 对于 服务器“HC-PC”失败。 (Microsoft.SqlServer.Smo)有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+ServerProdVer=1
错误信息:
标题: Microsoft SQL Server Management Studio ------------------------------ 附加数据库 对于 服务器“HC-PC”失败。 (Microsoft.SqlServer.Smo) 有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=附加数据库+Server&LinkId=20476 ------------------------------ 其他信息: 执行 Transact-SQL 语句或批处理时发生了异常。 (Microsoft.SqlServer.ConnectionInfo) ------------------------------ 无法打开物理文件 "D:\understructuredata _DAT.MDF"。操作系统错误 5:"5(拒绝访问。)"。 (Microsoft SQL Server,错误: 5120) 有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 ------------------------------ 按钮: 确定 ------------------------------
背景:
停止原数据库服务器sql server相关的拂去,从原数据库复制相应的数据文件(.MDF)与日志文件(.LDF)到目标数据库所在服务器。登陆数据库,选择附加,提示错误如下:
解决方法:
给数据文件(.MDF)与日志文件(.LDF),授予everyone的操作,如下图

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to transfer files from Quark Cloud Disk to Baidu Cloud Disk?

What to do if the 0x80004005 error code appears. The editor will teach you how to solve the 0x80004005 error code.

Where can I open the Douyin mini game? Two ways to open Douyin mini games

What is hiberfil.sys file? Can hiberfil.sys be deleted?

Different uses of slashes and backslashes in file paths

Detailed explanation of log viewing command in Linux system!

How to open Minesweeper? -How to mark small flags in Minesweeper?

Detailed explanation of the role of .ibd files in MySQL and related precautions
