Restore Verify only failing.

Question

Post reply

Restore Verify only failing.

mohan.bndr

SSCrazy

Points: 2360
More actions
February 10, 2022 at 6:25 pm

#3981756

We are having issue for backup restore from lower version 2012 to 2016. We copied the backup file over the network from other VM and did check the backup file using restore verify and this verify getting fail. Please help with your valuable suggestion.
February 11, 2022 at 11:48 am

This was removed by the editor as SPAM
April 18, 2022 at 6:15 am

This was removed by the editor as SPAM
April 18, 2022 at 11:45 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

The backup file is more than likely goosed.

Can you post the message it failed with like operating system error 13 or something , will be in the 2016 error log.

Rule out any issues at the source database side and run a DBCC CHECKDB against the source.

Backup to a different drive than you normally do and backup with checksum to add an extra check.

mohan.bndr SSCrazy Points: 2360 More actions · Answer 2

the Backup file validation failing with Msg 3203 read on .bak failed :13 ( the data is invalid) Msg 3013 Verify Database is terminating abnormally. Tried with all the possibilities with back up with checksum. no luck for me , though other DB backup files were good and only this back up file had an issue ( the size of the db is 212 GB). Please help on this to trouble shoot the issue.

This reply was modified 2 years, 9 months ago by mohan.bndr.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

Does the service account of the target server ( 2016 ) have read authority for the backup file ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

mohan.bndr SSCrazy Points: 2360 More actions · Answer 4

Yes. the service account had read permissions on target ( 2016) backup file.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

Just curious... not including the path of the file, what is the name and extension of the file? The reason I ask is it sounds like they didn't send you a backup file. It sounds like they sent you something else and the name and especially the extension might be a clue there.

Either that or, like Ant-Green suggested above, the file is goosed and you're going to have to try creating it again.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)