Restore of database on sql server

[Former Member]

Hi,

I have to restore quality system with production backup, but restore option in sql studio is grayed out due database related error.

Error is one of our .ldf file is corrupted and am not able to start my system. Below is the error mentioned:

Msg 926, Level 14, State 1, Line 1

Database 'RE2' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Msg 926, Level 14, State 1, Line 1

Database 'RE2' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Msg 9003, Level 20, State 9, Line 1

The log scan number (53933:202390:1) passed to log scan in database 'RE2' 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.

Msg 3414, Level 21, State 1, Line 1

An error occurred during recovery, preventing the database 'RE2' (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.

Please give valuable suggestions to resolve the issue.

Thanks,

Vikas

[Former Member]

Dear

whether you are restoring  offline backup or online backup if it is offline backuup see no user are locked your msg state you error msg no 5061 tell user is locked and you have to logged in with db user id not admin user id for system restore

Regards

[Former Member]

Must read this tutorial to eradicate SQL Error 926:

http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html