Forum Discussion

yobole's avatar
yobole
Level 6
10 years ago

FSAutility -t Bulk Recall issues

I am attempting to recall placeholders from one server to another using FSAutility –t –s \\myserver1\folder -d \\myserver2\folder.

I know there are over 900k placeholders on the source but it only recalls 300k.  As I’m not specifying and file types I would assume it would recall everything. 

There are only 1048 failures in the FSAutility log so it doesn’t match up.  Am I doing something wrong?

 

Backing Up
Basics
Enterprise Vault
Information Governance
Windows Server (2003-2008)
  • plaudone's avatar
    plaudone
    10 years ago

    yobole, 

    We would need to see what the orphaned report shows.  When you moved them from D to F did you run the task on F after the move?  This should have updated the paths in the DB so that they were shown as being on F.  

     

    You could also run the following query against the vault store DB to determine the number of items in each folder of that archive.  Would have to replace the SET @ArchivePointID value with the ArchiveID of from the Archive Properties Advanced tab.  You could then take the result and put into Excel to perform a sum on the items.

     

    DECLARE @ArchivePointID Nvarchar(55)
    SET @ArchivePointID = '1ACBC1EF4F328D7428E8664409FB5BC981110000EV8'

    SELECT
        r1.VaultEntryId as ArchiveID,
        Archive.ArchiveName,     
        CAST(folderpath as varchar(200)) as folder_path,
        COUNT(*) NumberofitemsperFolder
    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
        left  JOIN Vault on r2.Vaultentryid = Vaultid
        JOIN Saveset on Vault.Vaultidentity = Saveset.Vaultidentity
    WHERE 
        r1.VaultEntryId = @ArchivePointID
    GROUP BY 
        r1.VaultEntryId,
        Archive.Archivename,
        CAST(FolderPath as varchar(200))

  • plaudone's avatar
    plaudone
    Level 5
    10 years ago

    Hi yobole, Is it possible that there are items that are orphaned on the source folder?  Would need to run FSAUtility -o against that source in report mode to determine any orphans?  

    Or, if PH files were moved from another location to this one? They would not necessarily be in the DB in the location that they appear on the file system.  

  • yobole's avatar
    yobole
    Level 6
    10 years ago

    Hi Plaudone, many thanks for the reply.  We are now running an orphaned placeholder report and will await the results.  Your 2nd point is interesting as we did move all the placeholders last month from D: - F: using FSAUtility –PM and have since deleted D: as a target in EV.  Is there any way of getting all the files we need without running a bulk recall on the same server?

     

    Many thanks,

  • plaudone's avatar
    plaudone
    Level 5
    10 years ago

    yobole, 

    We would need to see what the orphaned report shows.  When you moved them from D to F did you run the task on F after the move?  This should have updated the paths in the DB so that they were shown as being on F.  

     

    You could also run the following query against the vault store DB to determine the number of items in each folder of that archive.  Would have to replace the SET @ArchivePointID value with the ArchiveID of from the Archive Properties Advanced tab.  You could then take the result and put into Excel to perform a sum on the items.

     

    DECLARE @ArchivePointID Nvarchar(55)
    SET @ArchivePointID = '1ACBC1EF4F328D7428E8664409FB5BC981110000EV8'

    SELECT
        r1.VaultEntryId as ArchiveID,
        Archive.ArchiveName,     
        CAST(folderpath as varchar(200)) as folder_path,
        COUNT(*) NumberofitemsperFolder
    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
        left  JOIN Vault on r2.Vaultentryid = Vaultid
        JOIN Saveset on Vault.Vaultidentity = Saveset.Vaultidentity
    WHERE 
        r1.VaultEntryId = @ArchivePointID
    GROUP BY 
        r1.VaultEntryId,
        Archive.Archivename,
        CAST(FolderPath as varchar(200))