attach without mdf - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

attach without mdf

Author

Topic

msc_timor
Starting Member

11 Posts

Posted - 2007-07-10 : 01:36:52

hi,
i've a serious problem. the disk in which my database was there was formatted, and when i recovered the data the mdf file is showing
0 bytes and the ldf files is about 2-3 GB. i cant attach the files

is there any solution

plz tell me

msc

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-07-10 : 02:02:15

MDF File is the primary file. And you need to have a correct MDF file before you attach.

From where you recovered the MDF and LDF files?

Don't sit back because of failure. It will come back to check if you still available. -- Binu

msc_timor
Starting Member

11 Posts

Posted - 2007-07-10 : 02:29:24

hi,

i gave the hard disk to the data recovery pro
the file were in the default location in c:\program files
mssql....\\......\data

the data rec is still trying

hope for best

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-10 : 04:04:45

How could you format a drive when obviously on system disk (c: partition) and maybe even sql server service running?

Peter Larsson
Helsingborg, Sweden

msc_timor
Starting Member

11 Posts

Posted - 2007-07-10 : 04:18:27

hi,

the HDD was not in the system. my collegue formatted the disk and loaded new os , but the main prob is that the mdf file after recovery is 0 bytes

msc

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-10 : 04:19:54

How did your collegue got a hold of the very important database disk?

Peter Larsson
Helsingborg, Sweden

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2007-07-13 : 03:43:39

I think I can predict the answer to this but do you have any backups of this database?

steve

-----------

Don't worry head. The computer will do all the thinking from now on.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-07-13 : 08:29:21

hopefully the backups aren't also 0 bytes...

elsasoft.org

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-07-13 : 11:37:24