• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4341
  • Last Modified:

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
0
crazywolf2010
Asked:
crazywolf2010
  • 3
  • 3
1 Solution
 
Luciano PatrãoICT Senior Infraestructure  Engineer  Commented:
Hi

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
0
 
crazywolf2010Author Commented:
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
0
 
Luciano PatrãoICT Senior Infraestructure  Engineer  Commented:
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
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
crazywolf2010Author Commented:
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
0
 
Luciano PatrãoICT Senior Infraestructure  Engineer  Commented:
Hi

Veeam create a copy of you VM. Veeam doesn't do a snapshot. It creates a snapshot only for the backup then delete that snapshot, then you will have any image of that VM.

Then you can restore the full VM, only some virtual disk, or files inside on each virtual disks, or now in the new version, restore some objects(AD, Exchange and SQL).

First I need to say that for me Veeam is the best backup tool for Virtual Environments. And I trust Veeam for backup any VM on Virtual Environments.

Bu I never did a fully test on a SQL Server and transactional/Archive logs.

But Veeam is not a SQL Backup. This what you need to understand.

If was and if I need to perform a backup of some SQL servers that are very important(with lots os transactional and big databases) I create a Veeam backup of that VM, then when is finish I create a backup of SQL transactional/Archive logs(with a proper tool).

Like I said I have done lots of backup for SQL Servers with Veeam, not as big as yours, and never had an issue. But this doesn't say that you may encounter.

But I think the best option for now, is to open a question in Veeam support forum. You can have more information, and maybe some examples from people that had the same issues and/or answer by the support guys.

PS: If you open, pelase provide the link for following.

Hope this can help

Jail
0
 
crazywolf2010Author Commented:
Thanks Jail. Let me do that and I will upload you a link if I see any solution there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now