SQL RESTORE FILELISTONLY query brings error in event viewer - BackupIoRequest::ReportIoError: read failure on backup device
0
votes
0
answers
418
views
I use the following query:
RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata' with CONTINUE_AFTER_ERROR
--or even like that
--RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata'
GO
output:
LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent TDEThumbprint SnapshotUrl
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---- -------------------------------------------------------------------------------------------------------------------------------- -------------------- -------------------- -------------------- --------------------------------------- --------------------------------------- ------------------------------------ --------------------------------------- --------------------------------------- -------------------- --------------- ----------- ------------------------------------ --------------------------------------- ------------------------------------ ---------- --------- ------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
dbRestoreToTime C:\dbRestoreToTime2012.mdf D PRIMARY 3145728 35184372080640 1 0 0 207A4430-91A0-4EFF-B9AB-44370D91D8E5 0 0 2424832 512 1 NULL 32000000041100037 F0DC3522-3C58-4AD0-A0BF-40CA3EE96793 0 1 NULL NULL
dbRestoreToTime_log C:\dbRestoreToTime_log2012.ldf L NULL 1048576 2199023255552 2 0 0 E83E06CD-2151-40EB-8660-DB3C3D58C334 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1 NULL NULL
dbRestoreToTime-2_log C:\dbRestoreToTime_log2012-2.ldf L NULL 1048576 2199023255552 3 31000000007400001 0 FE7D0324-6D8D-40BE-927A-6B9916505FD7 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1 NULL NULL
MyTestFileStore C:\FILESTORE2012 S TestFileStore 0 0 65537 31000000009800001 0 E9467C76-B305-4355-82F9-980DADDA7984 0 0 0 512 2 NULL 32000000041100037 F0DC3522-3C58-4AD0-A0BF-40CA3EE96793 0 1 NULL NULL
(4 rows affected)
Completion time: 2021-10-25T18:12:18.4750926+02:00
It works as expected, but unfortunately it generates the following error in the windows event viewer:
BackupIoRequest::ReportIoError: read failure on backup device 'E:\Tmp\metadata2012.metadata'. Operating system error 87(The parameter is incorrect.).
I can restore my database to a specific point in time and it works perfectly (there're several more steps required for that like attaching DB in
norecovery
state, creating VDI
device and applying logs but it's out of scope - DBCC
check gives no error on restored DB). The only one thing is the error in the windows event viewer. Do you have any idea why it's happening ?
SQL VSS
makes metadata2012.metadata
and it's part of the following backupcomponents.xml
:
(It's the metadata which I use for my RESTORE FILELISTONLY
query)
Asked by isxaker
(87 rep)
Oct 25, 2021, 04:18 PM
Last activity: Oct 27, 2021, 08:16 PM
Last activity: Oct 27, 2021, 08:16 PM