September 26, 2017 at 7:20 am
Hi All,
I am trying to restore a database from BLOB storage and getting the below error,
From: Application Logs
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1972. Thread=3344. Server. Instance=MSSQLSERVER. VD=Global\https://xxxxxxx.bak_SQLVDIMemoryName_0.
BackupIoRequest::ReportIoError: read failure on backup device 'https://xxxxx.bak'. Operating system error 13(The data is invalid.).
SQL Server Error Output:
Msg 3203, Level 16, State 1, Line 1
Read on "https://xxxx.bak" failed: 13(The data is invalid.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Tried with multiple copies of backup to different locations in BLOB container and still the same error.
Ran dbcc checdb on database with no errors and then performed the backup. still no luck.
Restore FilelistOnly and HeaderOnly are also having same problem.
---------------------------------------------------
Thanks,
Satheesh.
September 26, 2017 at 7:30 am
Satheesh E.P. - Tuesday, September 26, 2017 7:20 AMHi All,I am trying to restore a database from BLOB storage and getting the below error,
From: Application Logs
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1972. Thread=3344. Server. Instance=MSSQLSERVER. VD=Global\https://xxxxxxx.bak_SQLVDIMemoryName_0.BackupIoRequest::ReportIoError: read failure on backup device 'https://xxxxx.bak'. Operating system error 13(The data is invalid.).
SQL Server Error Output:
Msg 3203, Level 16, State 1, Line 1
Read on "https://xxxx.bak" failed: 13(The data is invalid.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.Tried with multiple copies of backup to different locations in BLOB container and still the same error.
Ran dbcc checdb on database with no errors and then performed the backup. still no luck.
Restore FilelistOnly and HeaderOnly are also having same problem.
Sounds like a corrupt file. Suggest you do another backup of the source DB immediately and verify that it can be restored.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 26, 2017 at 7:35 am
Tried it 3 to 4 times but no luck. Even ran dbcc checkdb and confirmed no fault on source db and then taken a backup.
---------------------------------------------------
Thanks,
Satheesh.
September 26, 2017 at 7:42 am
Strange: Moved the backup file to local storage and tried restoring. Still the same error,
Msg 3203, Level 16, State 1, Line 1
Read on "D:\xxxxx.bak" failed: 13(The data is invalid.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
---------------------------------------------------
Thanks,
Satheesh.
September 28, 2017 at 7:36 am
Found the problem. Database is enabled for encryption (probably someone had tested it) as it's a development environment. I tried restoring in a SQL Server 2016 version and got error related to certificate
Msg 33111, Level 16, State 3, Line 1
Cannot find server certificate with thumbprint '0x631C3B32762ABE2BA5DFE4AF63F1F6D16D98400E'.
Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
---------------------------------------------------
Thanks,
Satheesh.
September 30, 2017 at 1:09 pm
After droping the encryption key, I am able to restore the database.
---------------------------------------------------
Thanks,
Satheesh.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply