Archiving Data

Posted on 2011-05-12
Last Modified: 2012-05-11
I am using Arcserv to Archive data by using the Global Options. Is there a way to run a report by Modified file date? I have to give a report to management stating what files will be archived prior to the actual run. I looked at the Arcserv report and do't see anything that can be ran for file Modification date. Thanks!
Question by:Darrell Kirby
    LVL 61

    Accepted Solution

    What do you mean by archiving - a simple backup copy or deletion and eternal copy?

    Author Comment

    by:Darrell Kirby
    A deletion of records with a Modify date of 2006 and prior. I need to run a report and present to management showing these files prior to the deletion run.
    LVL 38

    Expert Comment

    Hi Jim

    I know nothing about the backup program you are referring to, but there are a number of ways you could create a report independently using a simple "DOS" batch file or a VBScript.  We would have to assume that the "Last Modified" dates found by the Arcserv program will match those found by windows CMD.exe and a VBScript, and that is something that I could not test.

    First of all, in Windows XP (maybe Win2000) and later the DIR command allows you to specify which of the Windows Dates are used to sort files.  DIR /?

    Example batch file that lists all file types in the given path and all sub-directories, excludes all results containing file 4-digit years of 2006 to 2001 and sorts the results by "last written" date with the oldest first.

    @echo off
    echo Creating File List report ...
    dir /a-d /od /tw /s /4 "C:\FolderName\*.*">"C:\_FileReport.txt"

    That includes all the DIR headers and splits the results into groups per-folder, but you can use that basic command and filter the results to compile a neat CSV list with just the file path and name, and the "last written" date.  A batch file can be given if you would like to try this.

    The other commonly used method is a CVScript that uses the FileSystemObject.  If you look at the suggestion given by Richard MuellerMVP, Moderator, on Tuesday, November 17, 2009 3:42 AM here:
    then you will find the code for a VBS file that allows you to specify a date (in the form MM/DD/YYYY) as your "files older than" point and which produces a listing of all files in the specified folder and all sub-folders with the "Modified" date prior to that date.  Optionally, and remarked out in the given code, is the option to delete the file if it is older than the given date.

    Is that something you could use?
    Would you like any explanations of how that VBS file works?

    LVL 38

    Expert Comment

    The requirement in the above VBS file was to list files OLDER than the given date.  If you changed the < to > in the line:
            If (objFile.DateLastModified < dtmDate) Then
    it would list files NEWER than the given date, and that may provide you with a cross-check with what would be archived.
    LVL 38

    Expert Comment

    Sorry, I was typing too fast and still thinking about CSV files.  Where I referred to "CVScript" it should have been "VBScript".
    LVL 38

    Expert Comment

    Hmmm.  Seems like a logical choice to accept a comment that just asks a question.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Learn about cloud computing and its benefits for small business owners.
    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
    This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now