• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

SQL 2005 Express Edition - Database Crash ( I dont have the Backup)


I am working on SQL 2005 Express Edition.

In the middle of my work, i faced severe Database Crash.

I dont have Database Backup - Is it possible for us to recover from .ldf ( Log Definition File)


Its an Emergency Request

0
chokka
Asked:
chokka
  • 11
  • 7
  • 6
  • +2
4 Solutions
 
chapmandewCommented:
check out www.apexsql.com.  they have a suite of tools to recover data.

What do you mean by "database crash"?
0
 
chokkaAuthor Commented:

We have back up of database till Dec 1,2009

But last night our database got crashed. So we lost records of this entire month.

So i am looking for some one to help us to recover the data of this entire month - or some tips to recover the data ..!
0
 
chapmandewCommented:
If you don't have a backup, then you might have some luck with third party tools (like I mentioned above).  Otherwise, you're out of luck.  
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
chokkaAuthor Commented:
ok . i am giving a try .. but its cost me around $1500 /- approximately ..! to buy the product ..!
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
no points :
  the trial version will work for 14 days
0
 
chokkaAuthor Commented:

Aneesh, i am little panic on using some third products ..! infact i have seen 14 days trial edition ..!

Which edition, i need to use?
0
 
chokkaAuthor Commented:

1) I dont have database backup .bak file

2) I have .ldf file

3) I need to get back my production database till last transaction before the crash


0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
Anthony PerkinsCommented:
>>ok . i am giving a try .. but its cost me around $1500 /- approximately ..! to buy the product ..!<<
So you are saying your data is worth less then $1500, then hire some data entry staff to re-input all the data.

Consider this as a valuable lesson to backup your data as often as the pain of losing it is bearable.  

If it is any consolation, we have all done this once, the trick is not to ever have to do it a second time ...
0
 
chokkaAuthor Commented:


I called Microsoft had a technical interaction with my Database.

They suggested me to approach any companies who can read .ldf file.

On reading .ldf file, we can extract Insert / Update / Delete records which we have to re-enter to the database manually.
I am looking for options to read .ldf file.  
0
 
chapmandewCommented:
btw..you'll have to buy products from such companies....apexsql being one of them.

you probably just spent $250 on a MS call...when you could have just used the trial version from apexsql to recover your data (if it is able to be recovered)
0
 
chokkaAuthor Commented:

ya, i paid $259 from MS ..!

Now, i am very much concern about .ldf file.

I need to read line by line to fetch the record from .ldf file.

0
 
chapmandewCommented:
>>I need to read line by line to fetch the record from .ldf file.

YOU cannot...you have to buy a product to do it.  I think red-gate has a product that can read SQL 2000 files for free, but all 2005 readers have to be purchased.
0
 
Mark WillsTopic AdvisorCommented:
And of course that assumes you have Full Recovery mode - without it you are pretty much sunk anyway. Fortunately it is the default in 2005 if you created your database there, and didnt change Recovery mode to Simple.

And with Full Recovery mode, you would have been running lots of transaction log backups - right ?

If you dont, then buying a product will be a waste, if you do, then try the trial version - they are good products - if it looks promising then get the full version.
0
 
Anthony PerkinsCommented:
>>Fortunately it is the default in 2005<<
I believe it should be set to Simple by default for Express versions and perhaps a prompt for the other editions to the effect of "Can you spell SQL? If not set it to Simple".  We get too many questions here on the subject.

>>And with Full Recovery mode, you would have been running lots of transaction log backups - right ?<<
What is a transaction log backup? :)
0
 
Mark WillsTopic AdvisorCommented:
G'Day acperkins :) :)


@chokka if you don't know, then the "default" behaviour is determined by the "model" database - it is a system database - you can check that by :

In SQL Server Management Studio Express, in Object Explorer, click the server name to expand the server tree to see a list of Databases.

In System Databases, click on that to reveal the System databases

Right-click the model database, and then click Properties, which opens the Database Properties dialog box.

In the "Select a Page" pane on the left, click Options.

The current recovery model is displayed in the Recovery model list box.

It should say FULL, so your default behaviour will be FULL Recovery (meaning Transaction Logs might be useful) unless it has been explicitly changed.

Now, if you have been doing transaction log backups then you should be able to use those against your last full back up - there is help in the Books On Line : http://msdn.microsoft.com/en-us/library/ms175093.aspx  note that step 4 is for each backup file of the transaction log
0
 
chokkaAuthor Commented:
hey . thanks all you guys ..!

I was with Microsoft Help support team  and so delayed in responding you all.

We have almost 30 tables . .. among that some where around 10 tables we lost entire value.

Now, we need to do recover from .ldf file for those 10 tables.  Log file Recovery
0
 
Mark WillsTopic AdvisorCommented:
What no transaction log backups either ? No disk image backups either ?

Well it is sounding very much like using a tool such as Apexsql.

Make a backup of what you currently have, use the trial, if it seems to be working then get the full version.

Not much more can be said really... Other than do your backups daily and transaction log backups frequently in between - there are tools to help you with that as well - the licensed versions of SQL Server also have things like scheduled maintenance plans (such as backups).
0
 
chokkaAuthor Commented:

Mark, I have sent .ldf file to Log Recovery Company - Its too expensive for us to do that process.

As its a live business production database, i decided to do so.

Also thanks all you guys for providing your inputs and suggestions. I will keep updated as soon as i have some good news.
0
 
Mark WillsTopic AdvisorCommented:
Sounds a great plan, and yes please, let us know how it works for you...

You might want to consider opening a new thread "Managing SQL Server Express and DR Plans"

And as a starting point, have a quick read of MS approach to Disaster Recovery (DR) : http://msdn.microsoft.com/en-us/library/ms178094(SQL.90).aspx

It is extremely important to have such a plan, because it is times just like these that they prove the effort.

Ironically, if you had one in place, you may never need to use it :)

If budget is so very tight, then this is also a good time to asses the real cost to the business, and maybe the purse strings might stretch just a little bit to get a good strategy in place (and that might just mean a bit of time) :)
0
 
chokkaAuthor Commented:
Hello all -

These are the steps  i followed

1) I called Microsoft Technical Help Desk - They came online - did their analyze - provided their feedback .ldf file is save

2) Then i approached a log recovery company, they worked on it on all the week end and provided back the database.

Now we got all the values.
Every thing is fine and perfect.

Thanks,
0
 
chapmandewCommented:
Awesome...please close out the question.
0
 
chapmandewCommented:
Sorry...split needed here.  I told you a lot earlier that you needed a 3rd party to do this.
0
 
chapmandewCommented:
answer:  mark_wills 26158038

assists:  
acperkins 26156751
chapmandew 26156019
0
 
chokkaAuthor Commented:

Mark's comment was so helpful for me.

I have to thank Mark.

0
 
Mark WillsTopic AdvisorCommented:
Well, that "thankyou" is very much appreciated, and certainly dont mind splitting points with the other experts.

I was thinking at one point that you might even award yourself the answer (sending out to a recovery bureau - well known but often overlooked) and maybe we would be lucky enough to get some assisted points - it is the most accurate and it is what worked ;)

I do recommend that you go through that recovery stuff, and set a DR plan...

And also please look at those backups. There is a terrific free tool talked about on : http://www.mssqltips.com/tip.asp?tip=1083 which you can download from that site or directly from : http://www.lazycoding.com/products.aspx

All the guys here know me, and also know that I am easy to please. So will leave entirely in your hands knowing that there was a special post just to say thanks :)

So, my recommendation would be more along the lines of :

answer:  
chokka : http:#a26173685  (author 0 points)

assists:  
acperkins http:#a26156751    (100 or 150 points or whatever you think)
chapmandew http:#a26156019  (100 or 150 points or whatever you think)
mark_wills http:#a26158038  (whatever is left - *laughing* if any)
0
 
Anthony PerkinsCommented:
I agree.
0
 
Mark WillsTopic AdvisorCommented:
hmmmm... an even split - so be it
0
 
chokkaAuthor Commented:
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 11
  • 7
  • 6
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now