I've a SQL 2012 Server setup on a VM, with 3 disks:
- Disk 1: 150GB --> System
- Disk 2: 750GB --> SQL mdf
- Disk 3: 750GB --> SQL ldf
DBs are in full recovery mode. Let's say we'll have 350GB of data in the DBs. This is a SharePoint 2013 databases server, but I don't think this impacts the backup strategy to adopt here. The VM itself (and all its disks) is replicated via Hyper-V replicas.
Is the following backup strategy acceptable?
- I plan full data backups every week to Disk 3. As far as I understand, this flushes out all transaction logs. I then remove backups from previous week.
- I plan logs backups every 1 hour to disk 2. I remove log backups older than 1 week.
With this strategy, I should optimize my disk space, and at worse, I lose 1 hour data? Am I correct? Will the logs backups (every 1 hour) have a noticeable impact on my server performances when they occur?