11-06-2017 10:12 AM - edited 11-06-2017 10:15 AM
Hello
We've successfully set up VMware backups with SQL GRT enabled and that's working well. I read that VMware backups can't be used for point in time recovery and am interested in how frequently these bacukps can run to reduce the RPO.
Ideally we'd like to do frequent log backups (say every 5 mins) on some of our critical SQL servers but is this feasible with VMware backups? We've enabled accelerator and only do backup to MSDP which is then replicated via AIR.
Is 5min backups using accelerator to agressive and if so what is a more realistic frequency between the backups..... all the databases are only in the low GB's in size and an agent based backup can typically protect the logs in well under 5mins.
hope that makes sense
thanks in advance
Solved! Go to Solution.
11-06-2017 10:29 AM
You can run accelerated backups as quickly as you can finish one and start the next. The problem with this is that it has to be full backup, and running full backup so many times will inflate the catalog drastically. It might be a better idea to use a traditional inguest backup method given the RPO you require.
11-06-2017 11:54 AM
11-06-2017 10:29 AM
You can run accelerated backups as quickly as you can finish one and start the next. The problem with this is that it has to be full backup, and running full backup so many times will inflate the catalog drastically. It might be a better idea to use a traditional inguest backup method given the RPO you require.
11-06-2017 11:54 AM
11-09-2017 11:36 AM
Many thanks for the feedback - I will use an agent based backup for the log files.