locked
Restore Database Error - SQL Error RRS feed

  • Question

  • I am trying to restore our CRM production database to a test SQL Server but I keep getting the error message:

    Read on "C:\backup.bak" failed: 13(The data is invalid).

    VERIFY DATABASE is terminating abnormally.

    I tried different backups and it all fails.

    Please advise.


    Arvin

    Thursday, November 14, 2013 10:49 PM

Answers

  • I figured out the issue.

    When I was copying the backup database, the steps I take are:

    Copy server1-source through \\server\c$ to the c:\ of server2-destination.

    The backup copies successfully. But when I try to restore it or verify it, the backup fails all the time.

    So I tried copying the same backup by doing these steps:

    Copy server1 - source c:\ to Network drive N:\ and from Network drive N:\ to server2 - destination c:\ .

    Backup copied successfully. Verify and restore database successfully without any errors.

    I'm not sure why it fails when I do the other step, but for now this is the solution to this issue.

    Thanks for all who tried to help.

    Arvin


    Arvin

    • Marked as answer by OrbusMan Monday, November 18, 2013 4:06 PM
    Monday, November 18, 2013 4:06 PM

All replies

  • This could be because of any difference in the SQL environment. Check if the Product and Test environment have the same version of SQL with similar updates and patches.

    - Arvind (My posts represent my own views and not of Accenture's)

    Friday, November 15, 2013 8:44 AM
  • Thanks for the reply Arvind.

    I noticed that it both have Service Pack 1 but the test server does not have Cumulative Update 3 and 4.

    I will install this and try to restore again.

    I will mark yours the answer if this solved the issue.

    Thank you!


    Arvin

    Friday, November 15, 2013 3:11 PM
  • To Update:

    I updated the SQL Server test environment by matching all the patches (CU 3 and 4) and Service Pack 1 in SQL Server Production

    Hoewever, even after installing these updates, I am still gettting the same error trying to restore the database.

    Any suggestions?

    Thank you,


    Arvin

    Friday, November 15, 2013 4:04 PM
  • Please try to enable SQL profiler to get more detail about error.

    http://technet.microsoft.com/en-us/library/ms175047.aspx

    Please check event viewer as well , if something related to this.


    Hope this helps. If you get answer of your question, please mark the response as an answer and vote as helpful !
    Vikram !

    Saturday, November 16, 2013 1:06 AM
  • I ran the SQL Profiler and here's what Event Viewer says: (Error)

    RESTORE detected an error page (0:0) in database "test.bak" as read from the backup set.

    Please advise.

    Thanks,

    Arvin


    Arvin

    Monday, November 18, 2013 3:14 PM
  • I figured out the issue.

    When I was copying the backup database, the steps I take are:

    Copy server1-source through \\server\c$ to the c:\ of server2-destination.

    The backup copies successfully. But when I try to restore it or verify it, the backup fails all the time.

    So I tried copying the same backup by doing these steps:

    Copy server1 - source c:\ to Network drive N:\ and from Network drive N:\ to server2 - destination c:\ .

    Backup copied successfully. Verify and restore database successfully without any errors.

    I'm not sure why it fails when I do the other step, but for now this is the solution to this issue.

    Thanks for all who tried to help.

    Arvin


    Arvin

    • Marked as answer by OrbusMan Monday, November 18, 2013 4:06 PM
    Monday, November 18, 2013 4:06 PM
  • Looks like your backup was demaged, while restoring please try with CONTINUE_AFTER_ERROR

    Note : there may be a data loss here.

    Regards
    Raju R

    Monday, November 18, 2013 4:22 PM
  • Hi

    Even after updating the Server Environment, you are not been able to access your backup database. I suggest you to check and repair your backup database with .bak Recovery software. Maybe that will help you to regain access to your backup database.

    Check this TechNet Gallery for further detail=>

    http://gallery.technet.microsoft.com/Affordable-Solution-To-43165a47

    Regards


    Sunday, November 24, 2013 11:51 AM