SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 attach without mdf		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

msc_timor
Starting Member

11 Posts
Posted - 07/10/2007 :  01:36:52  Show Profile  Reply with Quote
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

India
383 Posts
Posted - 07/10/2007 :  02:02:15  Show Profile  Reply with Quote
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
Go to Top of Page

msc_timor
Starting Member

11 Posts
Posted - 07/10/2007 :  02:29:24  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 07/10/2007 :  04:04:45  Show Profile  Visit SwePeso's Homepage  Reply with Quote
How could you format a drive when obviously on system disk (c: partition) and maybe even sql server service running?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

msc_timor
Starting Member

11 Posts
Posted - 07/10/2007 :  04:18:27  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 07/10/2007 :  04:19:54  Show Profile  Visit SwePeso's Homepage  Reply with Quote
How did your collegue got a hold of the very important database disk?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2039 Posts
Posted - 07/13/2007 :  03:43:39  Show Profile  Reply with Quote
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.
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2871 Posts
Posted - 07/13/2007 :  08:29:21  Show Profile  Visit jezemine's Homepage  Reply with Quote
hopefully the backups aren't also 0 bytes...

elsasoft.org
Go to Top of Page

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts
Posted - 07/13/2007 :  11:37:24  Show Profile  Visit dinakar's Homepage  Reply with Quote
quote:
Originally posted by jezemine

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

elsasoft.org




Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000