Sewer Video Project

MIS Department Policy & Procedure 

07/23/2012 KK-The sewer videos for the Sewer Video Project are now stored on a 1TB USB drive connected to Nick Costanzo's PC (DP1582). They are backed up onto another drive that is stored at the Garage.

Info about the backup process and the backup program is stored at

K:\D_Pub\Eng\San Sewer\Video Inspection\SewerVideoBackup

The same info is stored at I:\Net\PROJECT\SewerVideoDPS\SewerVideoBackupProgram, in case they mess up the program.

A shortcut to the batch file "Map V Drive - Shortcut"  that maps drive V:  (to Nick's PC) can be copied to a users Desktop, from: I:\Eng\San Sewer\Video Inspection\SewerVideoBackup

Backupvideos.bat will check that the drives are connected and are assigned the correct drive letters and will then use ROBOCOPY to syncronize the files from the primary drive to the backup drive. It is foolproof and will not copy anything unless the drives are connected properly.

This is the contents of the Instructions.txt file located in the above directory.

Instructions.txt

This directory

I:\Eng\San Sewer\Video Inspection\SewerVideoBackup

contains the program and log files for backing up the sewer videos from the primary

USB drive to the backup USB drive.

None of these files should be deleted or edited in any way unless to adjust for

drive letter changes due to new computer.

The primary sewer video drive is hosted on Nick Costanzo's computer DP1582.

This drive should have the drive letter F:

The backup sewer video drive will be stored at the DPS Garage and retrieved by

Nick when he is to perform a backup.

This drive should have the drive letter M:

The batch program BackupVideos.bat stored in this directory will do the following:

-Check for the existance of primary.txt on the primary drive F:

-Check for the existance of backup.txt on the backup drive M:

-If either of these do not exist the program will abort

-Ask user if they want to continue (y/n), abort if no

-Give final chance to abort with CTRL-C

-If proceeding, use ROBOCOPY to syncronize all files from F:\data2\video

from primary to backup drive M:

-Log username, date and time into videobackup.log

-END

The backup drive should be stored in a secure location at the Garage

and only connected to Nick's computer during the backup process.

The primary drive will have its DATA2 directory shared with everyone.

The share permissions will be set to READ ONLY for Everyone and Administrators.

The result of this will be Read Only permission for anyone connecting to the share.

The drive will be mapped as V: for those who need to access the videos.

Nick will also have the V: drive mapped and will have Read Only access

if using the V: drive.

This will protect the files during normal use.

Nick will have full Read/Write access if accessing the drive

as its native drive letter

BackupVideos.bat

ECHO OFF

IF NOT EXIST F:\primary.txt GOTO PROBLEM

IF NOT EXIST M:\backup.txt GOTO PROBLEM

BREAK ON

ECHO This will backup video files from Primary drive to Backup drive.

ECHO The Primary drive must be F: and the Backup drive must be M:

ECHO

ECHO DO YOU WISH TO CONTINUE? (y/n)

:LOOP

GETKEY

IF ERRORLEVEL 122 GOTO LOOP (122=z)

IF ERRORLEVEL 121 GOTO YES  (121=y)

IF ERRORLEVEL 111 GOTO LOOP (111=o)

IF ERRORLEVEL 110 GOTO NO   (110=n)

IF ERRORLEVEL 90 GOTO LOOP  (90=Z)

IF ERRORLEVEL 89 GOTO YES   (89=Y)

IF ERRORLEVEL 79 GOTO LOOP  (79=O)

IF ERRORLEVEL 78 GOTO NO    (78=N)

GOTO LOOP

:YES

ECHO YOU HAVE CHOOSEN TO PROCEED, THE DATA WILL BE SYNCRONIZED

ECHO ----

ECHO YOU HAVE ONE FINAL CHANCE TO ABORT THIS PROCESS BY PRESSING

ECHO CTRL-C ON THE KEYBOARD NOW, OTHERWISE PRESS

ECHO ANY KEY TO CONTINUE

PAUSE

@echo %date%,%time%,%username%>>"videobackup.log"

ROBOCOPY F:\data2\video M:\data2\video *.* /MIR /R:0 /W:0 /nfl /ndl /log+:videobackup.log

ECHO FINISHED

@echo ++++++++++++++++++++++++++++++++++++++++++++++++++++++>>"videobackup.log"

GOTO END

:NO

ECHO YOU HAVE CHOOSEN NOT TO PROCEED

ECHO THE BACKUP PROCEDURE WILL NOT BE PERFORMED

GOTO END

:PROBLEM

ECHO THERE IS A PROBLEM WITH THE DRIVE LETTERS ASSIGNED

ECHO TO THE USB DRIVES

@echo %date%,%time%,%username%>>"videobackup.log"

@echo BACKUP PROBLEM>>"videobackup.log"

@echo ++++++++++++++++++++++++++++++++++++++++++++++++++++++>>"videobackup.log"

:END

PAUSE