MSMSQL:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer...

BUG产生背景：

在将以前分离的下来的*.mdf即*.ldf恢复到数据时候，MSSQLServer总是出现如下错误提示！

BUG提示信息：

TITLE: Microsoft SQL Server Management Studio
        ------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'D:\xxx.mdf'. (Microsoft SQL Server, Error: 5123)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

BUG解决方案：

对于这个BUG没有找到一个可以直接的解决办法，不过可以通过一个转换的办法来实现，原来分离的数据的加载。那就是通过备份*.bak的备份文件，然后在目标MSSQLServer数据库中新建目标数据库，再通过覆写的方式来恢复数据库就可以达到预期的目标。

转载于:https://www.cnblogs.com/hipo/archive/2012/12/20/2826955.html