I have recently taken over the responsibility of a small business network of 35 users. I am a bit green on backup strategies and am considering my options.
We currently backup our SBS Server to tape (LTO 2). In addition, separately, we backup an SQL Server database. This database is critical to the business, and regulations state that we must be able to roll-back to a point in time up to 3 years in the past. The previous incumbents have simply taken a full back up every day for the last 18 months. This is now about 1.8 GB a night and there is about 920 GB already stored.
The database is currently backed up to a single external USB 2TB drive - clearly risky as if this fails, no data!
We have multiple geographic locations that are connected via point-to-point fibre optic i.e. exclusively ours, and all on the same subnet.
I propose to change the SQL Server backup plan to do once weekly full, with daily differential, and half-hourly log back up. I estimate that this will:
- take up less space;
- allow us more flexibilty to go back to a point in time, and;
- not lose 24 hours worth of data if we have a catastrophic failure.
For some reason, I have got it in my head that Tapes are the best form of backup for moving data offsite, but would mirroring the backed up database files over the fibre to a NAS in another location be an, or even more, effective form of backup?