当前位置: 技术问答>java相关
Recover from single *.mdf file
来源: 互联网 发布时间：2015-06-15
本文导语: Hello, Possible to recover database from a single *.mdf file? The *.mdf file does not exist on this databaseserver originally. I tried to use: exec sp_attach_single_file_db 'a', 'D:demodata_Data.mdf' and it returns that: Server: Msg 1813, L...
Hello,
Possible to recover database from a single *.mdf file? The *.mdf file does not exist on this databaseserver originally.
I tried to use:
exec sp_attach_single_file_db 'a', 'D:demodata_Data.mdf'
and it returns that:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'a'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:Program FilesMicrosoft SQL ServerMSSQLdatademodata_Log.LDF' may be incorrect.
Any suggestions for this?
Possible to recover database from a single *.mdf file? The *.mdf file does not exist on this databaseserver originally.
I tried to use:
exec sp_attach_single_file_db 'a', 'D:demodata_Data.mdf'
and it returns that:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'a'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:Program FilesMicrosoft SQL ServerMSSQLdatademodata_Log.LDF' may be incorrect.
Any suggestions for this?
|
go http://dbform.com
you should be able to find the solution
you should be able to find the solution
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。