Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle/SQL server transactional database backups using VEEAM

Posted on 2011-09-13
6
4,164 Views
Last Modified: 2012-08-14
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
Comment
Question by:crazywolf2010
  • 3
  • 3
6 Comments
 
LVL 23

Expert Comment

by:Luciano Patrão
ID: 36528492
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
 

Author Comment

by:crazywolf2010
ID: 36528509
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
 
LVL 23

Expert Comment

by:Luciano Patrão
ID: 36528552
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:crazywolf2010
ID: 36528719
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
 
LVL 23

Accepted Solution

by:
Luciano Patrão earned 500 total points
ID: 36528770
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
 

Author Comment

by:crazywolf2010
ID: 36528972
Thanks Jail. Let me do that and I will upload you a link if I see any solution there.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Teach the user how to configure vSphere Replication and how to protect and recover VMs Open vSphere Web Client: Verify vsphere Replication is enabled: Enable vSphere Replication for a virtual machine: Verify replicated VM is created: Recover replica…
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question