Aug 15 2021 07:37 AM
It was migration activity. We were moving to Azure and the SQL Server DB size was of 3 TB. Backup size was around 700 GB and we had split that into 10 files.
We used Azure file storage to move these files. After they were copied , when we tried to restore it, command was getting terminated .
Have attached the error.
So tried to verify them separately using restoreverify but the error was generic. How am i supposed to know which file has issue.
The error should give this information. And verify command doesnt work with single file.
Hence i ran command RESTORE HEADERONLY with all the 10 files.
And it was successful and gave the header info.
Hence i was confused and didn't know how to find the corrupt file.
So , i ran headeronly command against individual file and this worked like a charm . 9th file had issue and when i ran the command, it ran for couple of minutes and it failed.
Hence we copied that file again which took around 4 hours .
So 2 things which i require or seems it doesn't work like its supposed to be.
1. RESTORE VERIFY command should give info about all the files provided in the command .
2. RESTORE HEADERONLY command if ran with all the files, should either fail or give info in error about the corrupt file