Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This night my hosting provider made a "hard reset" on my VPS hosted in their farm. And one of most important databases (SQL Server 2008R2 database) is now in Suspect mode. My provider has backups (where 1 day of data will be lost) but they have closed for today and I really need to try everything that's possible before going with the old backup and trying to reinput all the data from other backup sources (like csv exports and pdf).

I've tried both tutorials like this one: http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp

And tried all these tools:

None of the three tools cold recreate the data, it's more than 10 days of lost data.

Is there anything else I should try or someone I should contact before start crying?

share|improve this question

migrated from stackoverflow.com Dec 19 '12 at 17:33

This question came from our site for professional and enthusiast programmers.

    
I think @SQLLearner meant to post this article, by Paul Randal, which may be worth a try, as a comment: sqlskills.com/blogs/paul/post/… –  Aaron Bertrand Dec 19 '12 at 18:22
2  
"my hosting provider hard reset my VPS ... and has closed for today" -- I strongly suggest switching to a hosting provider that actually knows what they're doing. +1 for sympathy. –  Jon Seigel Dec 20 '12 at 13:43
    
Its my personal experience you should go through this tool:- http://www.sqlrepairtool.org –  Enrique Jun 17 at 12:13
1  
Can you explain why you think that @user3571601 –  jcolebrand Jun 17 at 15:03

2 Answers 2

Sorry to be brief, but once you get this database restored (whether you can fix the suspect or have to revert to an older backup):

  1. Move to a host that doesn't shut down for the day, or that at least gives you a way to access backups without having to talk to them.
  2. You need to implement a better recovery plan for your "most important databases"... your backup options imply you are in simple recovery mode and you take a full backup nightly. Is that true? If so, you need to consider using full recovery and taking log backups, which will allow you to restore to a point in time instead of "last night's backup" - never mind "the backup from 10 nights ago."
  3. If you want to plan for disaster recovery you should be replicating something to a source not at this host. Log ship to a different data center, copy off BAK/TRN files, something.
share|improve this answer

You can try ApexSQL Recover, the option to recover from a corrupt database or detached MDF file

share|improve this answer

protected by Paul White Jun 17 at 12:34

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?