02-15-2021 09:17 AM
I just finish recover a vault archive deleted by mistake, it took 1 week, more then 20 TB of data. I'm trying to plan a faster restore. Used How to restore a single archive after it has been deleted in an Enterprise Vault site.
Is there a SQL script that enumerate with dvs* files an archive uses?
Our Backup team can restore files listed in a CSV
Thank you
António
02-16-2021 06:18 AM
What I got so far
SELECT A.ArchiveName, P.PartitionRootPath+'\'+ cast(datepart(year,ArchivedDate)as char(4))+'\'+ right(cast(datepart(month,ArchivedDate)+100 as char(3)),2)+'-'+ right(cast(datepart(day,ArchivedDate)+100 as char(3)),2)+'\'+ LEFT(IdTransaction,1)+'\'+ left(right(IdTransaction,len(IdTransaction)-1),3) AS Path, REPLACE(IdTransaction, '-', '' )+('.DVS') as DVSfile FROM EnterpriseVaultDirectory.dbo.archive A INNER JOIN EnterpriseVaultDirectory.dbo.ROOT R ON A.RootIdentity = R.RootIdentity INNER JOIN EVVSVaultStore_1.dbo.ArchivePoint AP ON R.VaultEntryId = AP.ArchivePointId INNER JOIN EVVSVaultStore_1.dbo.Saveset S ON AP.ArchivePointIdentity = S.ArchivePointIdentity INNER JOIN EnterpriseVaultDirectory.dbo.PartitionEntry P ON S.IdPartition = P.IdPartition AND A.ArchiveName = 'My Archive Name'
For exemple I got this output:
| ArchiveName | Path | DVSfile | | --------------- | ------------------------------------------------------------------------- | ------------------------------------ | | My Archive Name | M:\evstore\ptn03\Enterprise Vault Stores\VaultStore Ptn3\2013\11-27\B\028 | B02843D0A52045EF5CECF218640CC8F1.DVS |
So I search the filesystem looking for the files:
Get-ChildItem "M:\evstore\ptn03\Enterprise Vault Stores\VaultStore Ptn3\2013\11-27\B\028\B02843D0A52045EF5CECF218640CC8F1*.dvs*" Directory: M:\evstore\ptn03\Enterprise Vault Stores\VaultStore Ptn3\2013\11-27\B\028 Mode LastWriteTime Length Name ---- ------------- ------ ---- -a--- 27-11-2013 16:40 7738 B02843D0A52045EF5CECF218640CC8F1.DVS -a--- 27-11-2013 16:40 12627 B02843D0A52045EF5CECF218640CC8F1~4B~9A48F4B0~00~1.DVSSP
The item has 2 dvs* files, can we search the sql to find reference for this files?
Ref:
02-17-2021 12:46 AM
Hello again,
Nice one!
The 2 files are (as you know) belonging to the same item. I think you need to focus on the name of the DVS file (in your case B02843D0A52045EF5CECF218640CC8F1.
I have no clue if the DVSSP (and possible DVSSC) file have SQL references, and if so, where. I'd be interested to learn if you can find them.