FSA - query to count files in an archive

Hi,

There are 89 entries that will have to be added since each is a separate archive. I will go through one example from the data that was received.  

Use the following to add the volume to archive reference.  Only the second number will change as the volume is the same(F$).  This is example for entry 1 in the csv file.  

INSERT INTO [EnterpriseVaultDirectory].[dbo].[FileServerVolumeArchiveEntry]

           ([VolumeEntryId]

           ,[ArchiveVEID])

     VALUES

           ('1A0F39F88C54253459E178FA0082C5CE51011000EVARCHIVE'

           ,'182BC02E515AA5F47833A4F1211F5D5F11110000EVARCHIVE')

GO

Once the above is run you should be able to run FSAUtility using the following format:

FSAUtility -t -s  "\\sint02.SAFETYINSURANCENET.COM\F$\user\Clmccormac" -d "\\sint06.safetyinsurancenet.com\F$\user"

The -d path can be any location and does not need to be an FSA target.  This should restore all of the data from that archive to the destination path as -t is always recursive.  If files exist with the same name in the path they will not be overwritten unless the -f switch is used.  However, using this could cause partial data loss if the item has been updated, but not re-archived, since the archived copy would be older and replace the updated file.  

Then repeat the process for each of the other archives modifying the INSERT to update the second value for ArchiveVEID.  

After all is complete you can remove the source volume and target.  You can also delete the archives for each of the ones that was restored to clear up storage space.  

Regards,

Patrick