I am working on a sql database and it got corrupted due to power failure while I am doing some data entry on the system.
I set my database to emergency mode so that I could get some data out of it before dumping the database but I keep getting the error:
Could not continue with NOLOCK due to data movement
I set the database to offline mode and now when i try to turn it online.It is giving me this error
Set offline failed for Database 'xyz'.
The log scan number (1224:41:1) passed to log scan in database 'xyz' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
An error occurred during recovery, preventing the database 'xyz' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
Database 'xyz' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 9003)
Best Answer
The database is corrupt. Setting it to offline sealed your fate.
If it's mission-critical data that you need to recover, contact Microsoft Support. It's going to cost $500, but it's worth a shot if you need that data.
Otherwise, restore from backup.