Switch to full style
Data recovery and disk repair questions and discussions related to old-fashioned SATA, SAS, SCSI, IDE, MFM hard drives - any type of storage device that has moving parts
Post a reply

SQL Database

May 11th, 2010, 11:33

I have recovered some SQL databases for a client, MDF and LDF files but I have no way to verify the data is good or not.

Is there process available to verify this, or can this only be verified against a valid SQL installation?

thanks

Re: SQL Database

May 11th, 2010, 11:48

Best thing to do would be to mount the database in SQL. Depending on which version it is, you may be able to mount the database in SQL Express (free edition).

Re: SQL Database

May 11th, 2010, 13:59

Exactly. This is the easiest way to see if data is effectively consistent.

Re: SQL Database

June 28th, 2010, 3:42

how big is the DB file? coz it depends

i know few appz to verify and test sql tables but depends on the size i will suggest the app.
let me know
Post a reply