Skip to main content

Move Old Files to an Archive Folder

I have a folders structure where I store my scripts, backups, documents as shown below


The folders becomes cluttered with old versions of the files. So I decided to create a script that will move old files from each of the folders beneath the root one (e.g., C:\WP) to an archive sub-folder (if it exists at the particular level).
So I decided to archive old files in the Backups, Exchange, and SharePoint folders.
I created sub-folders called 'ARCHIVE' under each of those three folders as shown below


And then I created the following batch file



@ECHO OFF
SETLOCAL


SET ArchiveFolder=Archive
SET OlderThan=2
SET Extensions=TXT CSV BAK LOG


REM starts from the current folder 
REM   [when it's a scheduled task this is configured as "START IN"]
REM CD C:\WP


SET debug=ECHO 
SET LogFile="%~dpn0.LOG"




FOR /F %%m in ('CD') Do SET StartDir=%%m
%debug%.>>%LogFile%
%debug%.>>%LogFile%
%debug%.>>%LogFile%
%debug%  ***** Started on [%date%]  at [%time%]   ***** >>%LogFile%
%debug%      The Top Directory [%StartDir%]  >>%LogFile%
%debug%      Moving files older than [%OlderThan%] days >>%LogFile%
%debug%      with extensions [%Extensions%]   >>%LogFile%
%debug%      into [.\%ArchiveFolder%] subfolder >>%LogFile%
%debug%  ********************************************** >>%LogFile%
%debug%.>>%LogFile%


FOR /F %%i in ('DIR . /AD /B /S') DO (
if EXIST "%%i\%ArchiveFolder%" (
  %debug%   Moving files from [%%i] to [.\]%ArchiveFolder%  >>%LogFile%
  Call :MoveFiles %%i %Extensions%
  )
)


%debug%.>>%LogFile%
%debug%  ********************************************** >>%LogFile%
%debug%  *** Complete on [%date%] at [%time%]    ***** >>%LogFile%
Goto :EOF


REM ------------------------------------------------------------------
REM MoveFiles SourcePath Ext1 Ext2 .... Ext4
REM from [SourcePath] to [SourcePath\%ArchiveFolde%]
REM older than %OlderThan% days
REM


:MoveFiles
SET CurP="%1"
SET CurA="%1\%ArchiveFolder%"


:MainLoop
 SHIFT
 rem Now %1 referes to the next parameter (Ext1 or Ext2 or ...)


 if [%1]==[] Goto :EOF
 FORFILES 1>nul 2>nul   /P %CurP% /M *.%1 /D -%OlderThan% /C "CMD /c %debug%       **  Moving @path  >>%LogFile% "
 FORFILES 1>nul 2>nul   /P %CurP% /M *.%1 /D -%OlderThan% /C "CMD /c MOVE /Y @path  %CurA%"


goto :MainLoop


REM --------------------------------------------------------------




and scheduled it to run daily and configured the 'Start in' as C:\WP.
This script enumerates all sub-folders (recursively) for the current folder and if the current folder has a subfolder called 'ARCHIVE' it will move all files from the current folder into ARCHIVE provided the files are older than 2 days (configured in the script SET OlderThan=2) and their extensions are one within the list (SET Extensions=TXT CSV BAK LOG) also configured.

If you need to run this script manually then un-rem REM CD C:\WP  and change it to point to your top level folder.


Comments

Popular posts from this blog

SQL 2014 performance - Local disk vs. Azure Blob vs. Azure VM attached disk

Today I decided to compare SQL 2014 (RTM) performance when running a test against  - a local database (created on  WD7500BPKT - 750 GB 7200 RPM)  - a DB created on a disk attached to the A3 (3 cores, 7 GB) VM in Azure - a DB created on an Azure blob The VM in Azure was created in the US East region using the SQL 2014 template from the gallary provided by Microsoft. All databases were created with a single 10 GB data file (10 GB) and 1GB  log file. On the local SQL instance the DB was created as CREATE DATABASE TestDBonLocal ON     (NAME = file_data1, FILENAME = 'C:\TEMP\filedata1.mdf', SIZE = 10GB, FILEGROWTH = 256 MB )  LOG ON  (NAME = file_log1, FILENAME = 'C:\TEMP\filelog1.ldf', SIZE = 1GB, FILEGROWTH = 32 MB)  On the Azure VM the database on the attached disk (the disk was mapped as drive F:) was created as such CREATE DATABASE TestDBonDisk ON     (NAME = file_data1, FILENAME = 'F:\TMP\filedat...

Create 3-Node Windows 2012 Multi-subnet Cluster

Environment There are two Data centers connected via a WAN link. Two Windows 2012 Servers (called SQLDEV1 and SQLDEV2) are located in the Primary Data Center (on the IP subnet 192.168.79.0/24) and the third server is placed in the Secondary Data Center with the 192.168.69.0/24 subnet. We’ll be creating a three-node Windows cluster with no shared storage on the multi subnet network with a file share witness at the Primary Data Center. We’ll be using a file share witness to protect from the cluster failure in a situation when the network between the Data Centers is unavailable and one of the servers in the Primary Data Center is also down (or being rebooted). The final state will look like depicted above: -           Two Virtual IP’s will be assigned (192.168.76.218 and 192.168.69.134) to the cluster -           The servers at the Primary Data Center will have a vote (Vote=1) and the ...

SQL 2012 AlwaysOn: Synchronous vs. Asynchronous commit. Performance impact

Recently I've had a chance to build a 3-server AlwaysOn environment distributed between the primary and secondary data centers. The configuration looks like this: Primary Data Center                         Secondary Data Center                        SQLDEV1                                        SQLDEV3          SQLDEV2 The availability group was crated with synchronous commit replicas on SQLDEV1 and SQLDEV2 and the replica on SQLDEV3 was configured for asynchronous commit. The link between the data centers was not great and when I pinged SQLDEV3 from SQLDEV1 I got these results Approximate round trip times in milli-seconds:     Minimum = 39ms, Maximum = 63ms, Average = 42ms I also created a very simp...