Home » Blog » Topic » How to Resolve SQL Error 3013?

How to Resolve SQL Error 3013?

Andrew Jackson ~ Modified: July 29th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to Resolve SQL Error 3013?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • July 29, 2015 at 11:35 am #394 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    I get below error while restoring the database from backup file. I am using SQL 2008 R2 SP2 for this restoration-

    Location: bckioreq.cpp:1072
    Expression: 0
    SPID: 55
    Process ID: 1976
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    Msg 3624, Level 20, State 1, Line 1
    “A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support”.

    Any Idea how to fix it?

    July 30, 2015 at 11:37 am #404 Score: 0
    Stephen West
    Moderator
    4 pts

    Run the following command from Query Analyzer:

    RESTORE HEADERONLY FROM DISK=’C: \MyDatabase.bak

    August 28, 2015 at 8:58 am #532 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    This error message might be removed by using the following command. This will help erasing or deleting data from the backup device for allowing SQL Server program to implement new backup operation.

      “BACKUP DATABASE mydatabase TO DISK=’C: \MyDatabase.bak’ with FORMAT”
  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.