Eradicate Error 3414 how? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Eradicate Error 3414 how?

Author

Topic

alinazolii
Starting Member

4 Posts

Posted - 2014-08-06 : 03:04:05

I was running insertion query on SQL Server database to insert the employee’s details but suddenly the database got crashed. To recover it I run DBCC CHECKDB command but the command generates consistency error and gets fail to recover SQL database. Then I restore it from good backup which I had kept for disaster recovery and I can’t believe that suddenly SQL Error 3413 arise which states :-

Error: 3414, Severity: 21, State: 1.

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

Can you help me to take out this?

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-06 : 04:45:21

http://support.microsoft.com/kb/2015741

Javeed Ahmed

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-08-06 : 06:17:12

Hi alinazolii

If you got fail to recover SQL database from a backup, then must try below two options:
• Use the emergency repair method provided by DBCC CHECDB
• Try to copy out as much as is possible to another database
The first method is probably your best bet to get the database online and accessible. However, you must realize that transactional consistency cannot be guaranteed since recovery failed. There is no way to know what transactions should have been rolled back or rolled forward but were not allowed because of the recovery failure
If this method does not work and you want to try and copy data to another database, the only way to get access to the database is to first put the database in emergency mode by using the ALTER DATABASE <dbname> SET EMERGENCY command

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-06 : 06:34:48

Lincolnburrows-copied the matter from the above link I posted?
:)
Javeed Ahmed

prett
Posting Yak Master

212 Posts

Posted - 2014-08-13 : 02:00:43

Hi alinazolii,

You can also check below link:
http://www.stellarsqldatabaserecovery.com/recover-mssql-server-error3414.php

alinazolii
Starting Member

4 Posts

Posted - 2014-09-04 : 06:39:21

Thanks all! Appreciate your responses!!