We have a remote client that had to rebuild their server and has been having trouble with their SQL Express database since. I cannot remotely connect to this client unfortunately. I had them run "DBCC CHECKDB" and it showed one of the tables to be corrupted. I had them copy and send me the .mdf and .ldf files so that I could hopefully do something to resolve that.
I can't even attach that database though. I get the below errors when attempting to attach it...
Attach database failed for Server 'GW1\SQLEXPRESS'.
Could not continue scan with NOLOCK due to data movement.
Converting database 'QAData1' from version 655 to the current version 782.
Database 'QAData1' running the upgrade step from version 690 to version 691. (Microsoft SQL Server, Error: 601)
Any idea how I can get around this error or where I could look to possible get a better error message?
Any tips how I can repair a .mdf file if I can't attach it?