Forum Discussion

nils35's avatar
nils35
Level 4
11 years ago

Restoring all files using fsautility

Hi,

I am trying to restore all files for several shared folders which have been archived with EV. I have used the following command to restore all files for the EveryOne share: fsautility -t -s "\\bgo-file-01.domain.local\EveryOne" -d "\\bgo-p-vault-03\g$\EveryOne"

When it's done I have 86 630 files under \\bgo-p-vault-03\g$\EveryOne, but EV reporting says that it has 86 706 files archived from the EveryOne share. Looking at the xml report generated by fsautility, I can see that 42 files already existed (duplicates in EV), so I can deduct those. Still, I'm missing 34 files. How can I figure out which files are missing and why?

Thanks.

Enterprise Vault
Information Governance
Windows Server (2003-2008)
  • plaudone's avatar
    plaudone
    Level 5
    11 years ago

    nils35,

    The 'already existed' message should indicate that the file was already in the destination folder when the restore was attempted.  Was the target folder empty when the restore began? EV should only attempt to restore the latest version of each archived file so it should not restore duplicates(versions) to the same location.   

    The -f switch would have to be used to overwrite files that currently exist in the target location.  However, this can cause some data loss as the files located there may be newer than the ones in the archive so it should be used carefully.  Adding the -l 0 (zero) switch to the end of the command will log all failures and successes to the log file.  

     

     

  • nils35's avatar
    nils35
    Level 4
    11 years ago

    Hi, Thanks for replying.

    The destination folders are empty when running the command. The xml files are filled with "Already queued" and "File exists" messages, but not enough to explain all the missing files.

  • plaudone's avatar
    plaudone
    Level 5
    11 years ago

    Which report are you looking at for the information?  Also, what version of EV are you using? 

     

  • nils35's avatar
    nils35
    Level 4
    11 years ago

    I right-click on the Vault Store and choose Reporting. This brings up a Vault Store "File System Vault Store" detailed usage information table telling me the number of items in each archive. Then I compare this number with the number of restored files on the file system. Please let me know if there is a better way to verify if all files have been restored.

    We use EV 8.0 SP5.

  • plaudone's avatar
    plaudone
    Level 5
    11 years ago

    This would should you a Total number of items in the archive, including all versions of a file, as it is only a count of items within the archive and does not factor in the versions.  When FSAUtilty runs it will only restore the latest version of the file.  

    In order to get a list of items it would be necessary to query SQL and do some comparison on the output.

     

     

  • plaudone's avatar
    plaudone
    Level 5
    11 years ago

    You can run this query against the vault store and it will show you all files within that archive under FileName.  The ArchiveID will need to be replaced with that of the archive in question.  This can be found on the Advanced tab of the Properties page of the archive.  Once you have the output you can remove the duplicates in the FileName column to determine how many unique files there are in the archive.  


    DECLARE @ArchiveName nvarchar(75)
    DECLARE @ArchiveID nvarchar(75)
    DECLARE @FolderID nvarchar(75)
    DECLARE @Idtransaction nvarchar(40)

    --Change ArchiveID below to value
    SET @ArchiveID = '16249F038B3111642962A43B25043D24D1110000EV9'
    SET @ArchiveName = NULL
    SET @FolderID = NULL
    SET @Idtransaction = Null

    SELECT  
        Archive.ArchiveName,
        R1.VaultEntryId as ArchiveID,
        ArchivedDate, 
        IdTransaction, 
        ItemSize, 
        OriginalSize, 
        FileName =  convert(nvarchar(max),FolderPath) + '\' + substring(properties, (charindex('<filename>', properties)+10), 
                                        (charindex('</filename>', properties)-(charindex('<filename>', properties)+10)))                        
    FROM     
    EnterpriseVaultDirectory.dbo.root r1
        JOIN EnterpriseVaultDirectory.dbo.Root r2 on r1.RootIdentity = r2.ContainerRootIdentity
        JOIN EnterpriseVaultDirectory.dbo.archive on r1.RootIdentity = Archive.RootIdentity
        JOIN EnterpriseVaultDirectory.dbo.ArchiveFolder on r2.RootIdentity = ArchiveFolder.RootIdentity
        JOIN Vault on r2.VaultEntryId = Vault.Vaultid 
        JOIN Saveset ss on Vault.VaultIdentity = ss.VaultIdentity
        JOIN SavesetProperty sp on ss.savesetidentity = sp.SavesetIdentity
        LEFT JOIN Collection on ss.CollectionIdentity = Collection.CollectionIdentity 
    WHERE 
        r1.VaultEntryid= ISNULL(@ArchiveID, r1.VaultEntryid)
        AND ArchiveName = ISNULL(@ArchiveName, ArchiveName)    
        AND r2.VaultEntryid = ISNULL(@FolderID, r2.VaultEntryId)   
        AND ss.IdTransaction = ISNULL(@Idtransaction, ss.IdTransaction)
    ORDER BY 
        ArchivedDate DESC

  • nils35's avatar
    nils35
    Level 4
    11 years ago

    I deduct the number of "Already queued" and "File exists" messages in the xml file. Wouldn't that give me the total number of unique files? If I try to restore a share having multiple versions of a file, only one file is restored and the xml file logs either "Already queued" and "File exists".