The dvs file should be listed in the Vault Store database saveset table.
Try this query to determine the IDTransaction and folder path are correct:
Use 'Insert Name of Vault Store'
--Declare parameters
--Enter the DVS file under investigation here
declare @dvs varchar(36)
set @dvs = '499000000000000~200701261417260000~0.DVS'
declare @CSH int
declare @CSL int
declare @DT char(23)
declare @unique int
declare @dts varchar(200)
declare @time datetime
select @CSH = substring(@dvs, 1, 7)
select @CSL = substring(@dvs, 8, 8)
select @dt = substring(@dvs, 17, 17)
select @unique = substring(@dvs,34,1)
SET @dts = LEFT(@dt,8)+' '+
SUBSTRING(@dt,9,2)+':'+
SUBSTRING(@dt,11,2)+':'+
SUBSTRING(@dt,13,2)+'.'+
RIGHT(RTRIM(@dt),3)
Select @time = Convert(DateTime, @dts)
select
case when
SS.collectionidentity is null then 'Not Collected' else 'Collected'
end as Status
,IDtransaction
, '"' +
case when
SS.collectionidentity is null then
PartitionRootPath
+ '\' + convert(char(4),datepart(year, IdDatetime))
+ '\' + case when datepart(month, IdDatetime) < 10 then '0' + convert(char(1),datepart(month, IdDatetime)) else convert(char(2),datepart(month, IdDatetime)) end
+ '\' + case when datepart(day, IdDatetime) < 10 then '0' + convert(char(1),datepart(day, IdDatetime)) else convert(char(2),datepart(day, IdDatetime)) end
+ '\' + case when datepart(hour, IdDatetime) < 10 then '0' + convert(char(1),datepart(hour, IdDatetime)) else convert(char(2),datepart(hour, IdDatetime)) end
+ '\' + @dvs +'.dvs'+ '”'
else
case when charindex('.CAB', relativefilename) = 0 then relativefilename
else PartitionRootPath + '\' + relativefilename end
end as 'Location'
from collection
right join saveset SS on SS.collectionidentity = collection.collectionidentity
inner join Vault on SS.VaultIdentity = Vault.VaultIdentity
inner join EnterpriseVaultDirectory.dbo.VaultEntryView VEV on Vault.VaultId = VEV.VaultEntryId
inner join
EnterpriseVaultDirectory.dbo.PartitionEntry PE on SS.IdPartition = PE.IdPartition and PE.VaultStoreEntryId = VEV.VaultStoreEntryId
where savesetidentity in
(select savesetidentity from saveset where [idchecksumhigh] = @csh and [idchecksumlow] = @CSL and [iddatetime] = @time and [iduniqueno] = @unique)
