Preparing a final version for a client
Before handing it over, you want to check that you can restore the correct spreadsheet and an earlier usable version. The National Cyber Security Centre recommends testing backups by restoring files.
A NAS is a good fit if you regularly want to back up spreadsheets centrally from multiple devices or for a small team, and can manage the schedule and access permissions yourself. For one computer and a small collection of files, an external drive may be enough, as long as you stick to a reliable copying and recovery routine. Whichever option you choose, keep a separate copy and, before handing over the files, test that you can restore and open the correct spreadsheet version.
Before handing it over, you want to check that you can restore the correct spreadsheet and an earlier usable version. The National Cyber Security Centre recommends testing backups by restoring files.
You want document folders to be backed up automatically and regularly, rather than relying on manual copying. The National Cyber Security Centre recommends automating backups.
You want to decide who can access backups and, if they contain personal data, how long copies need to be kept. The Dutch Data Protection Authority emphasises appropriate security and retention periods that match the purpose.
A NAS is best suited to recurring backups from multiple computers or for a small team. For one computer and a few files, an external drive may be enough if you stick to a copying and recovery routine.
Choose this option if: you regularly back up spreadsheets from multiple devices or for a small team, and can manage the schedule and access permissions yourself.
Bear in mind: you’ll need suitable drives, configuration and ongoing management. Two drives in the same NAS don’t replace a separate backup.
Choose this option if: you’re backing up one computer and a small collection of files, and don’t need central access.
Bear in mind: it’s easy to forget to copy files manually. Keep a copy in another location too, as recommended by the National Cyber Security Centre.
| Consideration | What should you check? | Relevant consumers |
|---|---|---|
| Restorable versions | Check the versioning or snapshot features for the exact model and software. Test that you can restore and open a spreadsheet. | Before handing over a file, I want to be able to restore and open an earlier usable version. Around 36% of consumers prioritise restoring the correct version. |
| Automatic backups | Check that the exact model and chosen software support scheduled backups from the computers containing the spreadsheets. | If spreadsheets are updated on multiple computers, I don’t want to rely on manual copying. Around 29% of consumers prioritise automatic backups. |
| Access and retention period | Check user permissions and security features. If personal data is involved, define roles, risks and the necessary retention period. | If client files contain personal data, I want to restrict access and avoid keeping copies for longer than necessary. Around 21% of consumers prioritise controlling access to confidential information. |
| Complete setup | Compare the drives you’ll need, usable capacity and a separate backup destination. Consider whether an external drive will be enough for one computer. | Before buying a NAS, I want to know what components and management the complete backup setup will require. Around 14% of consumers prioritise a manageable overall setup. |
Mirroring drives within a single NAS doesn’t give you a separate copy if, for example, the whole NAS is lost or files are deleted. QNAP describes RAID as protection against certain drive failures, not as a replacement for a backup.
Alongside the NAS, plan a separate copy that you can restore, and keep a copy in another location, as recommended by the National Cyber Security Centre.
A successful task notification alone doesn’t show whether you can restore and open the spreadsheet you need.
Before handing over the files, restore a relevant version and open it. The National Cyber Security Centre recommends restoring files and, where necessary, carrying out a functional test.
Usable capacity depends on your chosen drives and configuration. A separate copy also requires a second destination.
Check compatibility for the exact model and work out how much usable space you’ll need for files, versions and the second copy. Synology notes that capacity can vary depending on the drives and RAID configuration.
Handing files over to a client doesn’t automatically mean every old copy can be kept indefinitely. The applicable retention period depends on the purpose and any other obligations.
For personal data, record who is responsible and how long the files and backups are needed. The Dutch Data Protection Authority states that personal data must not be kept for longer than necessary for the purpose.
For the DS223j, Synology describes scheduled backups of PC folders. For the DS225+, the manufacturer lists features including a 2.5GbE port.
QNAP presents the TS-233 as a two-bay model for storage and synchronisation, and lists snapshots and access security features.
The Drivestor 2 AS1102T is a two-bay alternative. ASUSTOR specifies one 2.5GbE port.
This Joybuy selection features Synology DiskStation NAS systems for centralised file storage and backup management. Check how you’ll back up spreadsheets from your computer and make a separate copy as well.
No image available
Synology describes DSM tools for backup and data protection. Check how you can also use them to back up the spreadsheet from your computer.
Hard drives are not included. The product information lists Synology HAT3300 and HAT5300 drives as compatible.
No image available
The product information lists DSM tools for file and backup management. Check that your chosen setup includes the spreadsheet from your computer.
No image available
The product information lists DSM apps for data backup. Check how you’ll also keep a separate copy outside the NAS.
Hard drives are not included.
Restore a file from the backup and open it. Also check that the version you want to send to the client is there. The National Cyber Security Centre recommends restoring files and, where relevant, carrying out a functional test.
Don’t assume that you can: Synology warns that the installation may format and erase a drive containing existing data. Make a separate copy beforehand and check that the drive is compatible.
Include the compatible drives you’ll need and a separate backup destination in your decision. The components required depend on your existing equipment, storage needs and backup setup.
Not necessarily straight away, and there isn’t one fixed retention period. According to the Dutch Data Protection Authority, personal data must not be kept for longer than necessary for the purpose. Other legal obligations may also apply. Establish the relevant period and arrangements for this data, and include backups in your plans.
Not simply because you use a NAS. According to the Dutch Data Protection Authority, a written data processing agreement is required when one party processes personal data on behalf of another organisation as a processor. First establish the actual roles involved. Appropriate security remains important whenever personal data is processed.