Oracle/SQL server transactional database backups using VEEAM
Hi All,
I have number of Vmware Oracle 10g/11g & SQL server 2005/2008 database servers. We use Veem backup to preserve server installations/binaries. My impression is , veeam backups don't work well with transactional systems. Hence we carry quest litespeed sql server & Oracle rman database backups separately.
I discovered this link http://forums.veeam.com/viewtopic.php?f=4&t=1141 where someone is saying veeam works well with oracle 11g if you have "Oracle VSS Writer" enabled.
I wish to know if anyone here have an experience of using VEEAM with Oracle/SQL server.
Thanks
I have number of Vmware Oracle 10g/11g & SQL server 2005/2008 database servers. We use Veem backup to preserve server installations/binaries. My impression is , veeam backups don't work well with transactional systems. Hence we carry quest litespeed sql server & Oracle rman database backups separately.
I discovered this link http://forums.veeam.com/viewtopic.php?f=4&t=1141 where someone is saying veeam works well with oracle 11g if you have "Oracle VSS Writer" enabled.
I wish to know if anyone here have an experience of using VEEAM with Oracle/SQL server.
Thanks
ASKER
Hi,
Thanks for your input.
Are these databases highly transactional? I am asking because the only issue I see is SQL server transaction log backup which will be at inconsistent state when VEEAM backup was taken.
The question is how VEEAM manages that in case a recovery is needed? OR it will be OK if we manually backup logs after VEEAM backup?
Thanks
Thanks for your input.
Are these databases highly transactional? I am asking because the only issue I see is SQL server transaction log backup which will be at inconsistent state when VEEAM backup was taken.
The question is how VEEAM manages that in case a recovery is needed? OR it will be OK if we manually backup logs after VEEAM backup?
Thanks
Hi
Using Windows VSS integration I do not see any issues.
Do not forget that Veeam in not plan to be a SQL\Oracle backup tool. Only as a VM backup.
Even in the new v5 version we can have more features using Veeam to backup/restore SQL objects, you should use another Backup tool to backup your SQL databases.
Jail
Using Windows VSS integration I do not see any issues.
Do not forget that Veeam in not plan to be a SQL\Oracle backup tool. Only as a VM backup.
Even in the new v5 version we can have more features using Veeam to backup/restore SQL objects, you should use another Backup tool to backup your SQL databases.
Jail
ASKER
Hi,
This is what I am trying to understand what precisely does it do and what I should carry manually.
Is it possible to carry veeam server backup first and then backup of transactional/Archive logs for recovery or you wish to say just do full database backups and don't trust VEEAM at all.
Some of these databases are around 200GB in size and carrying database backups on tier 4 storage takes at least couple of hours for us during day time.
Why VEEAM ?
- The Veeam snapshots are very quick so we want to use it for database backups.
- Besides that VEEAM snapshots copy entire server state so we know everything is there if we want to roll back. Some of my database servers also host apps servers on dev/test platform.
Many Thanks
This is what I am trying to understand what precisely does it do and what I should carry manually.
Is it possible to carry veeam server backup first and then backup of transactional/Archive logs for recovery or you wish to say just do full database backups and don't trust VEEAM at all.
Some of these databases are around 200GB in size and carrying database backups on tier 4 storage takes at least couple of hours for us during day time.
Why VEEAM ?
- The Veeam snapshots are very quick so we want to use it for database backups.
- Besides that VEEAM snapshots copy entire server state so we know everything is there if we want to roll back. Some of my database servers also host apps servers on dev/test platform.
Many Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Jail. Let me do that and I will upload you a link if I see any solution there.
With Oracle never tested(need to test this), but with SQL, I have several SQL servers working and backup with Veeam.
And in on case, we need to restore all the servers, and restore all the servers(2 SQL included) and found no issues.
Not big SQL servers/databases, but holding some databases for several applications.
Jail