My company ships an appliance that runs on Windows Server 2008 R2 Standard. It runs SQL Server 2008 Express R2 as well. The appliance generates content by recording video from IP cameras so we generate a lot of data every day. I'd say a typical installation writes 2-3 GB worth of data every day assuming our users don't record more content than usual on a particular day.
There are a few things of interest to me in terms of what I'd like to back up:
- The media
- The database
Ideally this would work seamlessly with the rest of the application as that's the main selling point of this product.
It seems easy to backup the database because it usually stays quite small (less than 100 MB). I'm wondering if there is any good way to backup all that video content though. I'm imagining that we're going to need to build something in house eventually but even that sounds like it'd be a lot of work to keep going.
Any suggestions would be much appreciated. Thanks!