62,614
社区成员
发帖
与我相关
我的任务
分享Recover from single *.mdf file
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 Files\Microsoft SQL Server\MSSQL\data\demodata_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 Files\Microsoft SQL Server\MSSQL\data\demodata_Log.LDF' may be incorrect.
Any suggestions for this?
...全文
请发表友善的回复…
发表回复
Conductor 2002-06-04
- 打赏
- 举报
go http://dbform.com
you should be able to find the solution
you should be able to find the solution
soldier1002 2002-06-03
- 打赏
- 举报
help
soldier1002 2002-06-03
- 打赏
- 举报
?
soldier1002 2002-06-03
- 打赏
- 举报
?
