SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Eradicate Error 3414 how?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alinazolii
Starting Member

4 Posts

Posted - 08/06/2014 :  03:04:05  Show Profile  Reply with Quote
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

India
666 Posts

Posted - 08/06/2014 :  04:45:21  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
http://support.microsoft.com/kb/2015741

Javeed Ahmed
Go to Top of Page

Lincolnburrows
Starting Member

42 Posts

Posted - 08/06/2014 :  06:17:12  Show Profile  Reply with Quote
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
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
666 Posts

Posted - 08/06/2014 :  06:34:48  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Lincolnburrows-copied the matter from the above link I posted?
:)
Javeed Ahmed

Edited by - ahmeds08 on 08/06/2014 06:35:06
Go to Top of Page

prett
Posting Yak Master

USA
203 Posts

Posted - 08/13/2014 :  02:00:43  Show Profile  Visit prett's Homepage  Reply with Quote
Hi alinazolii,

You can also check below link:
http://www.stellarsqldatabaserecovery.com/recover-mssql-server-error3414.php
Go to Top of Page

alinazolii
Starting Member

4 Posts

Posted - 09/04/2014 :  06:39:21  Show Profile  Reply with Quote
Thanks all! Appreciate your responses!!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000