locked
backup set error when the bak file restore RRS feed

  • Question


  • hello when i want to restore my backup file that, i take in sql server 2017 that name is (VNLite1_13981228_114430.bak)

    i got error :

    TITLE: Microsoft SQL Server Management Studio

    Restore of database 'VNLite1' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "VNLite1" as read from the backup set. (Microsoft.SqlServer.SmoExtended)

    my backup very important and i do not have time for while, is there solution, please help me.

    Tuesday, April 7, 2020 10:27 AM

All replies

  • RESTORE detected an error
    Use RESTORE Statements - VERIFYONLY (Transact-SQL) to check if the backup file is valid or may damaged.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Tuesday, April 7, 2020 10:34 AM
  • If you see this error when restoring a backup file, you may be trying to restore a newer version of SQL Server. Sometimes this error can also mean that your backup file is corrupt. In such a case, you can use SysTools BAK File repair tool to recover data from a corrupted backup file.
    Tuesday, April 7, 2020 10:38 AM
  • i use same sql sever and then i chat the person who is systools supporter

    so my file is compressed and the tool does not support for recovery.

    Tuesday, April 7, 2020 10:58 AM
  • excuse me

    i am basic in sql server please

    use example for query

    my file name is E:\28.bak

    and then use this query

    RESTORE FILELISTONLY
    FROM DISK = 'E:\28.bak'

    RESTORE HEADERONLY FROM DISK ='E:\28.bak'

    and the result is abot many of feild backup file

    Tuesday, April 7, 2020 11:01 AM
  • excuse me

    i am basic in sql server please

    use example for query

    my file name is E:\28.bak

    and then use this query

    RESTORE FILELISTONLY
    FROM DISK = 'E:\28.bak'

    RESTORE HEADERONLY FROM DISK ='E:\28.bak'

    and the result is abot many of feild backup file

    Tuesday, April 7, 2020 11:03 AM
  • What does the restore with option VERIFYONLY return?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, April 7, 2020 11:20 AM
  • RESTORE VERIFYONLY FROM DISK = 'E:\28.bak';
    GO

    VERIFY DATABASE is terminating abnormally.

    this message when use verify script.

    Tuesday, April 7, 2020 11:26 AM
  • can you help or know someone SQL specialist ?

    Tuesday, April 7, 2020 1:51 PM
  • RESTORE VERIFYONLY FROM DISK = 'E:\28.bak';
    GO

    VERIFY DATABASE is terminating abnormally.

    this message when use verify script.

    Hi hamedmotaghi,

    >> RESTORE VERIFYONLY FROM DISK = 'E:\28.bak';GO
       VERIFY DATABASE is terminating abnormally.
        this message when use verify script.

    It seems your bak file is corrupted, please follow the given command to recover SQL Server corrupt backup file.

    CONTINUE_AFTER_ERROR

    Please refer to How To Recover SQL Server Corrupt Backup File (.bak) to get more information.

    If you can’t using SysTools Tool, pleae try to use Stellar Toolkit for MS SQL, please refer to How to restore corrupt .BAK file using Stellar Toolkit for MS SQL.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, April 8, 2020 3:39 AM
  • any of answers does not result i think there is way to recover but need time. thanks a lot

    i think my answers can be better than this,

    Microsoft must be a forum or a site or ... for it specialist to answer question for it man like me,

    because when ask a question Microsoft i use any of way there is.

    thanks a lot

    i can work and i love work with Microsoft but i do not know how can i join you?

    Thursday, April 9, 2020 11:49 AM