SQL Server 2008 R2 database is suspect, tried it all. Final destination?

Question

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:

• http://www.sql.recoverytoolbox.com/
• http://www.kerneldatarecovery.com/sql-recovery.html
• Stellar Phoenix SQL Recovery

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?

Answer 1

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.

Answer 2

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