I have a situation regarding MS SQL Server database.
My friend ask me to repair a certain database, because a range of data has been lost after a hard disk failure, but eventually after troubleshooting, swapping the data cables of the two HDD with software RAID 1 configuration, the hard disk has been restore and operational, but, unfortunately, a range of data is nowhere to be found.
Question: What do you think happened to the data? corrupted? The data has been corrupted when the hard disk failed? Can I recovered that data?
MS SQL Server 2000 MS Windows Server 2003 R2
Thanks.