| 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 andLDF 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 likeI/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 ShawSQL Server MVP |
 |
|
|
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 extractdata from ldf? |
|
|
|
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 ShawSQL Server MVP |
|
|
|
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? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
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 ShawSQL Server MVP |
|
|
|
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 |
|
|
|
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 ShawSQL Server MVP |
|
|
|
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. |
|
|
|
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. |
|
|
|
jakeliu
Starting Member
3 Posts |
|
|
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 |
|
|
|
|
data recovery