1. General

1.1. The 3-2-1 Backup Rule

  • Three data copies (production data and 2 backup copies).

  • Two different media (disk and tape).

  • One offsite copy (for disaster recovery).

2. Tape Backups

2.1. Tape Backup Schedule

The tape backup schedule can be found in the T:\IT\Helpdesk\SMRU Backup Schedule folder on the file server.

2.2. Information

  • Regardless of the tape name the

    • Backup on Wednesday contains a complete bootable backup of each VM and the data on that VM.

    • Backups on Thursday through to Tuesday (different tape due to Thursday tape change) contain a complete bootable backup of each VM and the data on that VM for everyday that week (Wednesday, Thursday, Friday, Saturday, Sunday, Monday, Tuesday).

  • Wednesday backup tape only contains complete VM backup (and therefore data on all drives) on the day the backup was made.

  • Thursday tapes contain complete VM backups for Wednesday through to the following Tuesday.

  • The only difference between weekly, monthly, quarterly and yearly backup tapes being:

    • Weekly backup tapes rotate and get overwritten every 5 weeks.

    • Monthly backup tapes rotate and get overwritten every 3 months.

    • Quarterly and yearly backup tapes don’t rotate and never get overwritten.

2.3. Tapes

The backup tapes are stored in the left room upstairs in the cross border office 1. The cross border office 1 keys with the blue label are in the server room.

2.3.1. Backup

2.3.1.1. Weekly

The backups are created automatically. We just have to insert a new tape every Wednesday and Thursday at late afternoon.

2.3.1.2. Quaterly
2.3.1.3. Yearly

2.3.2. Restore

Restore of backups is done by Veeam Backup Enterprise Manager.

2.4. Tape Drive

Dell CSEH 001 tape drive.

Tape drive status message: Amber flashing exclamation mark with amber "C".

2.5. Problems

2.5.1. Tape drive status messages: C in flashing amber

  • See T:\IT\Documentation\Manuals\Tape Drives\Dell PowerVault 110T LTO-3 Tape Drive\LTO Media Hanbook (40105MR).pdf

  • Flashing amber: Need to clean the tape drive.

  • Eject the current tape from the drive.

  • Insert Universal Cleaning Cartridge tape into the tape drive.

  • Note: No seven segment display indicator.

  • Note: Activity light blinks green and tape ejects when finished.

  • Reinsert the original tape again.

  • Note: It should display the green light.

3. Hard Disk Backups

For each share two identical backups are made on two separate hard disks. The hard disk is connected to the computer using a docking station that plugs into the computer with a USB cable. After the share has been backed up on both hard disks, one hard disk is stored in the SMRU server room and the other hard disk is stored offsite at the Crossborder room across the road.

BitLocker is used to encrypt the partitions of the hard disks.

The backup schedule is every last Friday of the month. When done please complete the Disks Backup Schedule form.

3.1. Backup Archive$ Share

All archived data is stored on the \\SMRU-HyperV01\Archive$ share. This share is mapped to the A: drive. Because the A: drive contains important data it has been decided to not mirror but archive the A: drive to the external hard disks. This means that any file or folder deleted from the A: drive is not deleted from the external hard disk. However, files and folders on the external hard disk will be overwritten. Because of this we ideally should use hard disks that are larger than the external hard disk (1 TB) used for the Archive$ share.

3.2. Mirror Archive$ Share

All archived data is stored on the \\SMRU-HyperV01\Archive$ share. This share is mapped to the A: drive. Because the A: drive contains important data it has been decided to keep a synchronised copy of the A: drive. This copy is an external hard disk of the same size as the external hard disk (1 TB) used for the Archive$ share. It also means that any file or folder deleted from the A: drive is also deleted from this synchronised external hard disk.

Using the volume label instead of the drive letter ensures that the Archive$ share is always synchronised to the right hard disk regardless of what drive letter it has been assigned.

The external hard disk is encrypted so it must be unlocked first, otherwise the SMRU-Archive task will fail.

The synchronisation is done once an hour, every 30 minutes past the full hour using a scheduled task on a desktop computer. The installation of the task is shown below and is only needed once.

  • Log on as <User>.

  • Enter the following commands at a Command Line.

    schtasks.exe /Create /TN SMRU-Archive /XML "%ProgramData%\Delta Software Labs\Windows-Tools\SMRU-BackupArchive.xml"

The SMRU-Archive task starts the following action.

powershell.exe -Command "Import-Module -DisableNameChecking -Name 'C:\Program Files\Delta Software Labs\Windows-Tools\Backup.psm1'; Invoke-Backup A:\ 'Archive Mirror' -Mirror"

The SMRU-Hide.vbs script prevents the Command Prompt window from showing when the task is triggered.

3.3. Mirror TBHFWS-IT02 Data

  • Log on as <User>.

  • Enter the following commands at a Command Line.

    Invoke-Backup D:\ 'Data Mirror' -Mirror

3.4. Mirror VirtualBox$ Share

All the VirtualBox virtual machines are stored on the \\TBHFWS-IT01\VirtualBox$ and \\TBHFWS-IT02\VirtualBox$ shares. These shares are mapped to the V: and Q: drives respectively.

Because in theory it is possible to re-create all virtual machines in case of data loss it has been decided to mirror the V: drive to the external hard disks. This means that any file or folder deleted from the V: drive is also deleted from the external hard disk. This allows us to use hard disks of the same size as the external solid state disk (500 GB) used for the VirtualBox$ share.

3.5. Mirror Windows$ Share

All downloaded drivers, images and software is stored on the \\SMRU-HyperV01\Windows$ share. This share is mapped to the W: drive. Because in theory it is possible to download all files again in case of data loss it has been decided to mirror the W: drive to the external hard disks. This means that any file or folder deleted from the W: drive is also deleted from the external hard disk. This allows us to use hard disks of the same size as the external hard disk (2 TB) used for the Windows$ share.

3.6. Mrs. Suphak

  • Contents of the X:\Media2Media-Mirror.cmd file.

    @echo off
set "Module=%ProgramFiles%\Delta Software Labs\Windows-Tools\Backup.psm1"
set "Command=Invoke-Backup Media Media-Mirror -Mirror"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command%"

  • Contents of the X:\Media2Media-Backup.cmd file.

    @echo off
set "Module=%ProgramFiles%\Delta Software Labs\Windows-Tools\Backup.psm1"
set "Command=Invoke-Backup Media Media-Backup"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command%"

3.7. SMRUNB-DC04 Dr. Rose

  • Contents of the D:\Master2Chiang.cmd file.

    @echo off
set "Module=%ProgramFiles%\Delta Software Labs\Windows-Tools\Backup.psm1"
set "Command=Invoke-Backup Master Chiang -Mirror"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command%"

  • Contents of the D:\Master2Maesot.cmd file.

    @echo off
set "Module=%ProgramFiles%\Delta Software Labs\Windows-Tools\Backup.psm1"
set "Command=Invoke-Backup Master Maesot -Mirror"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command%"

  • Contents of the D:\Sync2Master.cmd file.

    @echo off
set "Module=%ProgramFiles%\Delta Software Labs\Windows-Tools\Backup.psm1"
set "Command1=Invoke-Backup "D:\ANC"     Master -Mirror"
set "Command2=Invoke-Backup "D:\Data"    Master -Mirror"
set "Command3=Invoke-Backup "D:\Letters" Master -Mirror"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command1%"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command2%"
powershell.exe -Command "Import-Module -DisableNameChecking -Name '%Module%'; %Command3%"

4. Hard Disk Backup Restore Test

5. Clinics

  • People can store files on the Other$ share that is located on the ANC server.

  • Note: The ANC server has RAID1, but no backups are made of the share.

6. MSP Study

Todo: Check with Tobias.

7. Ultrasound Images

We are saving ultrasound images every 4 weeks for the TDF study. This will involve 170 women with scans done every month for 5-7 months. We want to know the best way to get these backed up. The scans will arrive on a memory stick each week. The MSP study also does this but we don’t know where they are stored. These images are patient data and should be kept in a secure location (password protected).

8. Verena

Todo: Check with Verena.

9. Website

  • Start Browser.

  • Browse to https://www.lonex.com/members.html

    Username:       shokloun
Password:       ********

  • Select Files > File Manager.

  • BHF: Right-click bhf-th.org and select Download > Compressed as zip.

  • SMRU: Right-click shoklo-unit.com and select Download > Compressed as zip.

  • Choose Save File.

  • Click OK.

  • Select Databases > MySQL Databases.

  • Click the Database backup icon for the shokloun_db_smru.

  • Select Databases > MySQL Databases.

  • Click the Database backup icon for the shokloun_drupal7.

  • Select Databases > MySQL Databases.

  • Click the Database backup icon for the shokloun_ei.

  • Select Databases > MySQL Databases.

  • Click the Database backup icon for the shokloun_ei1.

  • Select Files > File Manager.

  • Right-click mysqlbackup and select Download > Compressed as zip.

  • Choose Save File.

  • Click OK.

  • Copy the bhf-th.org.zip, mysqlbackup.zip and shoklo-unit.com.zip files to A:\T\IT\Backups\Lonex websites\yyyy-mm-dd folder.

  • Wait for the downloads to finish.

  • Close Browser.

10. Unifi Controller

  • Browse to https://10.10.1.4:8443.

  • Logon as SMRU user with the Ubiquiti - UniFi Account password stored in the KeePass Password Manager.

  • Select Settings > System > Backups.

  • Click Download.

  • Select No Limit.

  • Click Download.

  • Copy the network_backup_xxxxxxxxxxxxxxxxxxxxxxxx.unf file to the A:\T\IT\Backups\Lonex websites\yyyy-mm-dd folder.

  • Close Browser.

11. Image