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
 General SQL Server Forums
 Data Corruption Issues
 data recovery
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sunilmadkar
Starting Member

India
4 Posts

Posted - 02/28/2009 :  05:49:18  Show Profile  Send sunilmadkar a Yahoo! Message  Reply with Quote
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

Edited by - sunilmadkar on 02/28/2009 07:08:49

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/28/2009 :  08:23:07  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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

India
4 Posts

Posted - 03/01/2009 :  06:49:30  Show Profile  Send sunilmadkar a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 03/01/2009 :  07:44:42  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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

India
4 Posts

Posted - 03/01/2009 :  23:25:04  Show Profile  Send sunilmadkar a Yahoo! Message  Reply with Quote
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

USA
37460 Posts

Posted - 03/01/2009 :  23:51:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 03/02/2009 :  03:04:18  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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

India
4 Posts

Posted - 03/06/2009 :  23:42:15  Show Profile  Send sunilmadkar a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 03/07/2009 :  03:20:30  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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 Posts

Posted - 04/02/2012 :  07:56:25  Show Profile  Reply with Quote
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 - 04/20/2012 :  06:43:20  Show Profile  Reply with Quote
May be your .mdf and .ldf data is corrupted and not accessible. You should try a third party tool which can tackle the situation.

Edited by - tkizer on 07/25/2012 12:30:43
Go to Top of Page

jakeliu
Starting Member

USA
3 Posts

Posted - 02/27/2013 :  04:12:29  Show Profile  Reply with Quote
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 - 04/08/2013 :  05:52:02  Show Profile  Reply with Quote
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
  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.11 seconds. Powered By: Snitz Forums 2000