Home » Topic » How to Remove Microsoft SQL Server Error 3456?

How to Remove Microsoft SQL Server Error 3456?

Matt Johnson ~ Modified: October 30th, 2017 ~ ~ 1 Minute Reading

Home › Forums › How to Remove Microsoft SQL Server Error 3456?

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • October 30, 2017 at 7:19 am #5536 Score: 0
    Matt Johnson
    Moderator

    I faced an I/O failure and then performed shutdown of my SQL Server database. Then I created a cold backup of the files at a different location. When I restarted the SQL database, it was displayed as marked as Suspect. After detaching the database and reattaching it after I did restore from the backup I got the error message “Error 3456 .could not redo record”. Can someone provide any solution to this?

    October 30, 2017 at 7:58 am #5545 Score: 0
    Dexter Morgan
    Moderator
    38 pts

    Hey,
    I see that you mentioned about SQL Server error 3456 and also about your database being marked as suspect. The main cause for it can be corruption in your MDF files or the log files of the database. This is why you have been seeing this error message on screen.

    October 30, 2017 at 8:19 am #5553 Score: 0
    Matt Johnson
    Moderator

    Thanks for helping me understand the cause for it but I need a solution to get rid of this problematic situation. Is there any manual solution that I can implement that would allow me to resolve this SQL server error 3456 easily?

    October 30, 2017 at 9:10 am #5554 Score: 0
    Dexter Morgan
    Moderator
    38 pts

    Yes there is a manual way you can deploy to solve this error and it will require you to follow three main steps

    • First Rebuild DBs from System
    • Then Perform Restore from Backup
    • After that, Reinstall SQL Server on your system

    I should warn you beforehand that this process will be very time-consuming.

    October 30, 2017 at 10:00 am #5564 Score: 0
    Matt Johnson
    Moderator

    You were right!
    I tried to solve the error through the steps you mentioned above but it took up a lot of my time and that too without any success. Is there a workaround to remove SQL server error 3456 quickly?

    October 30, 2017 at 11:05 am #5569 Score: 0
    Dexter Morgan
    Moderator
    38 pts

    I would then suggest that you should make use of a third party software solution which would help you to recover from SQL server error 3456 without any fuss and wastage of time.

    Get the help of this time saving software solution here: http://www.sqlrecoverytool.com/

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.