HDD crash took out SQL

Posted By geekinc over 10 years ago

Had a drive crash yesterday with major corruption that had me reinstall OS, then I reinstalled SQL and SAGE 100 ERP Premium. I have searched but haven't found how to utilize our databases that I pulled off the bad drive. This is a new install with no backup since it crashed before the backup ran on a day that a ton of info was put in.

Is there any way to utilize the settings and databases that were saved?

I've been up 27 hours trying to get back to where I was two days ago, so forgive me if I'm not making sense.

Any help or insight would be great.

0 JRobinsonVLS over 10 years ago

Geekinc

Find your last good Full SQL backup. That's starting point #1. Hopefully that backup isn't too far in the past. Next you should attempt to recover all available transaction logs.

You should be able to replay the transaction logs since the last full backup to allow you to get to the most recent available data.

Use the following articles to give yourself an idea of what the process entails, HOWEVER - I recommend you contact your reseller immediately and get their assistance rather than striking out on your own.

www.techrepublic.com/.../restore-your-sql-server-database-using-transaction-logs

msdn.microsoft.com/.../ms190982.aspx

After you're up and running again, I recommend you implement best practices to store your transaction logs on a different drive (and ideally server) than the SQL server itself. It is recommended to make regular backups of the transaction log (hourly is a good idea in a heavy data environment) between regular full nightly backups.

Good Luck!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

HDD crash took out SQL

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING