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
 General SQL Server Forums
 Data Corruption Issues
 data recovery

Author  Topic 

sunilmadkar
Starting Member

4 Posts

Posted - 2009-02-28 : 05:49:18
i am using sql server 2000. yesterday my server shown blue screen after that when i start again it was showing messges like registry or system files corrupted....
after that i remove HDD from server and put it on another machine to copy databse files(.mdf and .ldf) but i found that mdf file size has changed from 1.6 GB to 2048 KB and
LDF file showing 1.6 GB from 2048 KB. after that i was trying to copy both files into new location, but only able to copy MDF file which is 2048 KB. while copying ldf file i am getting message like
I/O error. i don't have latest backup.
so i want to know after recovering ldf file from HDD can i will be able to get back my original database. pls help.
Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-02-28 : 08:23:07
What's the exact error that you got trying to copy?
How big is the LDF and how big should it be?

If the MDF should be 1.6GB but is 2048kb, it indicates that it's been truncated by the OS and it will not attach. If that's all you have, that database is a total loss. Do you have any backups at all?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sunilmadkar
Starting Member

4 Posts

Posted - 2009-03-01 : 06:49:30
mdf and ldf size should be 1.6 gb and ldf 2048 respectively.
i agree suppose mdf file has truncated by os, but what's the meaning of 1.6 gb ldf?
can i use that to recover data partially? else is any third party solution which help me to extract
data from ldf?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-03-01 : 07:44:42
quote:
Originally posted by sunilmadkar

but what's the meaning of 1.6 gb ldf?


Who knows. If the files are that badly messed up, anything could have happened.

quote:
can i use that to recover data partially?

No. The log just contains changes and if it's supposed to be only 2 MB, if won't contain very much. It's useless unless you can back it up and you have a full backup and an unbroken chain of log backups.

quote:
else is any third party solution which help me to extract data from ldf?

Not that I'm aware of, besides, there won't be much in a 2MB log file.

All the 3rd party log readers that I know of require the DB to be available through SQL.

No backup?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sunilmadkar
Starting Member

4 Posts

Posted - 2009-03-01 : 23:25:04
yes..i have back up but it is one month back.

i have log file (ldf) which size is 1.6 gb(latest one), so will it be helpfull to recover data using third party software?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-01 : 23:51:12
You can not use third party software to recover data with just an LDF file.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-03-02 : 03:04:18
quote:
Originally posted by sunilmadkar

yes..i have back up but it is one month back.

Restore it. It's the best you're going to get here.

Why do you not have recent backups?

quote:
i have log file (ldf) which size is 1.6 gb(latest one), so will it be helpfull to recover data using third party software?


As I explained above, no.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sunilmadkar
Starting Member

4 Posts

Posted - 2009-03-06 : 23:42:15
i got my lost data!
i just changed ldf file as mdf and mdf file as ldf, after that both files attached to new dummy database, and it's worked.
But Still i am wondering how it was happned.

thanks for help
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-03-07 : 03:20:30
IO system messed up. Who knows. You got lucky.

Now, go and set up a regular backup job so that, if something like this happens again, you won't have to worry about losing data.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

annice
Starting Member

1 Post

Posted - 2012-04-02 : 07:56:25
unspammed is best solution to recover your corrupted, lost, deleted or formatted .mdf or .ldf file in few simple steps. It is simple to use and compatible with SQL server 2000, 2005, 7.0, 2008. It is available in demo and full version.
Go to Top of Page

Stephen2913
Starting Member

5 Posts

Posted - 2012-04-20 : 06:43:20
May be your .mdf and .ldf data is corrupted and not accessible. You should try a third party tool which can tackle the situation.
Go to Top of Page

jakeliu
Starting Member

3 Posts

Posted - 2013-02-27 : 04:12:29
else is any third party solution which help me to extract
data from ldf?


_________________
runescape gold|wow gold kaufen|diablo 3 gold|Swtor Credits



Go to Top of Page

davegeeit
Starting Member

11 Posts

Posted - 2013-04-08 : 05:52:02
Database of MS SQL Server is stored in .MDF file format either on Server or local drive. MDF files get damaged due to slow running of SQL Server, virus codes, accidental deletion of files and other factors. With RecoveryFix for SQL database, you can retrieve user data such as triggers, views, tables, hyperlinks and stored procedures from corrupt MDF files. It recovers SQL database in its original text formatting.

Thanks
Go to Top of Page
   

- Advertisement -