Restore detected an error on page

I"m attempting to restore a SQL Server 2012 .BAK file to my local server. I"ve properly recovered this .BAK file before. However currently, once I attempt, I obtain the complying with error:

RESTORE detected an error on web page (0:0) in database "databasename" as read from the backup set.

You watching: Restore detected an error on page

Running the following command also works:

RESTORE HEADERONLY FROM DISK = "D:database.bak"However, running the following:

RESTORE VERIFYONLY FROM DISK = "D:database.bak"Retransforms the following error:

Msg 3203, Level 16, State 1, Line 1Read on "D:database.bak" failed: 13(The data is invalid.)Msg 3013, Level 16, State 1, Line 1VERIFY DATABASE is terminating abcommonly.I downloaded the .BAK file from an FTP server aobtain this morning and acquired the exact same error. I asked someone else with accessibility to the exact same backup file and they can restore it through no concerns at all. Any ideas?


sql-server backup
Share
Improve this question
Follow
asked Sep 23 "13 at 18:40
*

ScottScott
11311 gold badge11 silver badge66 bronze badges
Add a comment |

1 Answer 1


Active Oldest Votes
2
Check that you are downloading with binary transfer mode making use of FTP. Many clients will try to autodetect, then fall earlier to binary. .bak may not be known as binary, and might therefore have actually all "s interpreted to , corrupting the data.

If that is not the instance, make sure the server version you are attempting to restore through is newer or equal to the server version the original backup was taken through. See SELECT
VERSION for an easy to compare examine.

Beyond that, assuming the original backup functions fine in other places, do a binary checkamount of both records... perhaps some disk error or various other transport is bring about corruption. You can use fciv.exe -add c:database.bak or a comparable energy to calculate the checkamount.

See more: Stop Firefox Opening Links In New Window

It is additionally possible to take a good backup of a corrupt database. The original database can be corrupt - I do not recognize why it would certainly have restored effectively elsewhere, but it might take place. You have the right to verify the original database by running DBCC CHECKDB("DatabaseName") WITH NO_INFOMSGS, ALL_ERRORMSGS on the server the backup was tackled.


Share
Improve this answer
Follow
edited Dec 16 "14 at 20:05
answered Sep 23 "13 at 18:54
*

MitchMitch
2,2351313 silver badges2121 bronze badges
2
Add a comment |

Your Answer


Thanks for contributing a response to Server Fault!

Please be sure to answer the question. Provide details and share your research!

But avoid

Asking for assist, clarification, or responding to other answers.Making statements based on opinion; back them up via references or individual endure.

To learn even more, check out our tips on creating excellent answers.

See more: Dell Laptop Checking Media Fail On Windows Startup, How To Fix Checking Media Fail On Windows Startup


Draft saved
Draft discarded

Sign up or log in


Sign up making use of Google
Sign up utilizing Facebook
Sign up using Email and also Password
Submit

Blog post as a guest


Name
Email Required, but never shown


Article as a guest


Name
Email

Required, but never before shown


Message Your Answer Discard

By clicking “Message Your Answer”, you agree to our regards to company, privacy policy and cookie policy


Not the answer you're looking for? Browse other concerns tagged sql-server backup or ask your own question.


The Overcirculation Blog
Featured on Meta
Related
1
Why does Server 2008 running SQL 2008 create a FlushFileBuffer exception?
0
just how i deserve to regain my earlier up file?
5
Is the master database backup important for restoring MS SQL server in the event wright here you have to reclaim from backup and construct database server from scratch?
15
SQL Server reclaim a backup outcomes in an error
1
Downfill databasename.bak file
0
Unable to reclaim database using Microsoft SQL Server Management Studio Express
1
I had actually to drop and reclaim database aobtain. I had the ability to drop however acquired error while restoring. deserve to any kind of one please help me how execute i settle this problem
1
Rekeep SQL 2008 database fails with error on web page xxx:xxx
0
Restarting MSSQLSERVER organization on the major or on the mirror the database is collection in “In Recovery” mode
0
Rekeep SQL Database From BAK Documents utilizing a SQL Query
Hot Netjob-related Questions even more hot concerns

Inquiry feed
Subscribe to RSS
Question feed To subscribe to this RSS feed, copy and paste this URL right into your RSS reader.


*

Server Fault
Company
Stack Exadjust Network-related
website style / logo © 2021 Stack Exreadjust Inc; user contributions licensed under cc by-sa. rev2021.4.1.38963


Server Fault functions best through JavaScript allowed
*

Your privacy

By clicking “Accept all cookies”, you agree Stack Exadjust deserve to store cookies on your tool and discshed indevelopment in accordance through our Cookie Policy.