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

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数据库中新建目标数据库,再通过覆写的方式来恢复数据库就可以达到预期的目标。

posted @ 2012-12-20 19:48  斯洛波维亚  阅读(2705)  评论(2编辑  收藏  举报