Chandra Shekhar Kumar Tech

 In today’s digital world, data management and backup are crucial for maintaining a secure and efficient workflow. Whether you’re managing important business files, personal data, or projects, ensuring that your files are safely backed up is always a priority.

For those looking for an easy, automated solution to backup their data regularly without much manual intervention, this blog post will guide you through setting up a batch script that automatically backs up your  data from a local drive to Google Drive and manages old backups by deleting files older than 7 days.

Why Automate Your Backups?

Manual backups are time-consuming and prone to errors. Forgetting to backup important files or accidentally overwriting existing backups can lead to potential data loss. By automating the process, you ensure that:

• Your files are consistently backed up without manual effort.
• Storage space is optimized by automatically deleting old backups.
• The process is streamlined and requires minimal intervention once set up.

How This Script Works

The batch script outlined here achieves all the key goals for an automated backup system. Let's break down the process step by step.

1. Setting Up the Source and Destination

First, the script specifies where the source data is located and where you want to store the backups.

• Source Folder: This is where your BUSY data resides on your local machine (in this case, D:\BUSY-BACKUP).
• Destination Folder: This is where the backup will be saved. We’re using Google Drive to store the backup, specifically in G:\My Drive\Backup Data.

2. Creating a Unique Backup Folder with a Timestamp

Each time the script runs, it creates a unique backup folder. The name of the folder includes a timestamp to ensure that every backup is stored in a separate folder and there is no risk of overwriting any previous backup.

For example, the folder name might look like backup_20241126_2000, where 20241126_2000 represents the date and time the backup was created.

3. Backing Up New and Modified Files

The script checks for files that have been modified or added to the source folder since the last backup. It compares the last modified date and time of each file with the previous backup's timestamp.

• New files or files that have changed since the last backup are copied to the newly created backup folder.
• This ensures that only updated or new data is backed up, saving time and storage space.

4. Tracking the Last Backup

To know when the last backup was taken, the script maintains a last_backup.txt file in the destination folder. This file stores the date and time of the last successful backup. The script uses this information to decide which files need to be backed up.

Each time the script runs, it:

• Reads the timestamp from last_backup.txt.
• Compares the modification date and time of files in the source folder with the last backup time.
• If the files are newer, they are copied to the destination.

5. Updating the Last Backup Timestamp

After each backup, the script updates the last_backup.txt file with the current date and time, making it ready for the next backup.

6. Automatically Deleting Old Backups

To keep your storage clean, the script automatically deletes backups older than 7 days. This is done using the forfiles command, which scans the backup directory and removes backup folders that haven’t been updated in the past 7 days.

This ensures that your Google Drive backup storage doesn’t get cluttered with old, unnecessary files.

The Benefits of Automating Your Backup

With this script in place, you’ll benefit from:

1. Consistent Backups: Your BUSY data will always be backed up regularly without the need to remember to do it manually.
2. Efficient Storage Management: By deleting backups older than 7 days, you won’t be taking up unnecessary space in Google Drive.
3. Time-Saving: The process runs in the background, and you don’t need to spend time copying files every time you make changes.
4. Security: Your important data is stored securely in Google Drive, providing an additional layer of protection against data loss.

Setting Up the Script

If you want to set up this batch script on your system, follow these simple steps:

1. Create a Batch File:

   • Open Notepad.
   • Copy the entire script provided above into Notepad.
   • Save the file with a .bat extension (e.g., backup_script.bat).

2. Customize the Source and Destination Folders:

   • Modify the source and destination paths to match your system’s configuration. For example, change D:\BUSY-BACKUP to the correct location of your source folder and G:\My Drive\Backup Data to your Google Drive folder.

3. Run the Script:

   • Double-click the batch file to run the script. The first time it runs, it will create a backup folder, copy the files, and create the last_backup.txt file.

4. Schedule the Script:

   • If you want the backup to run automatically at regular intervals, you can schedule the batch script to run using Task Scheduler in Windows.

Conclusion

Automating backups can save you a lot of time and effort. With this simple batch script, you can ensure that your BUSY data is regularly backed up to Google Drive, with new or modified files being copied, and old backups being cleaned up automatically. By setting up this system, you can rest assured that your data is always safe, secure, and well-organized.

If you have any questions or need further assistance with the script setup, feel free to leave a comment below!

And batch file code below:- 

@echo off

setlocal enabledelayedexpansion

rem Set the source folder (BUSY-BACKUP directory)

set "source=D:\BUSY-BACKUP"

rem Set the destination folder (Backup Data folder)

set "destination=G:\My Drive\Backup Data"

rem Create a timestamp for the backup folder name

set "timestamp=%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%"

set "timestamp=!timestamp: =0!"  rem Replace space with zero for hour

rem Create a new backup folder with timestamp

mkdir "%destination%\backup_!timestamp!"

rem Check if the last backup file exists

if exist "%destination%\last_backup.txt" (

    rem Read the last backup timestamp from the file

    set /p last_backup=<"%destination%\last_backup.txt"

) else (

    rem If no last backup file exists, set the default to a date far in the past (e.g., 1 year ago)

    set last_backup=01/01/2023 00:00:00

)

rem Convert the last backup date to a timestamp for comparison

for /f "tokens=1,2 delims= " %%a in ("%last_backup%") do (

    set last_date=%%a

    set last_time=%%b

)

rem Loop through the target folders (8pm, 9pm, 13pm)

for %%d in (8pm 9pm 13pm) do (

    rem Loop through the files in the subfolder

    for /r "%source%\%%d" %%f in (*) do (

        rem Get the file's last modified date and time

        for /f "tokens=1,2 delims= " %%x in ('dir "%%f"^| findstr "%%~nxf"') do (

            set file_date=%%x

            set file_time=%%y

        )

        rem Compare the file's last modified time with the last backup time

        rem Note: file_date and file_time format: MM-DD-YYYY HH:MM AM/PM

        if !file_date! GTR !last_date! (

            rem File is modified after last backup, so copy it

            xcopy "%%f" "%destination%\backup_!timestamp!\" /H /C /I /Y

        ) else if !file_date! == !last_date! (

            rem If it's the same date, check the time

            if !file_time! GTR !last_time! (

                rem File is modified after the last backup time, so copy it

                xcopy "%%f" "%destination%\backup_!timestamp!\" /H /C /I /Y

            )

        )

    )

)

rem Update the last backup timestamp with the current date and time

echo %date% %time% > "%destination%\last_backup.txt"

rem Delete backups older than 7 days

forfiles /p "%destination%" /m "backup_*" /D -7 /C "cmd /c rmdir /S /Q @path"