We have a SQL server live database that needs to be backed up. It's too large to run as part of our online backups and not important enough. However it'd be a bummer if we lost it but would not have a negative business impact.
I have sectioned off a NAS device with 300GB or space. The databases are about 150GB in size. I only need one copy of the DB per week. I can overwrite the DB from two weeks ago when backing up each week. Which basically I only even need two full copies of the DB and the other ones can be overwritten.
We dont have any backup software in place and the company are unlikely to invest as it's not deemed important enough.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention.
Multiple USB devices need t…