[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Oracle/SQL server transactional database backups using VEEAM

Posted on 2011-09-13
6
Medium Priority
?
4,260 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
[X]
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
  • 3
  • 3
6 Comments
 
LVL 24

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 24

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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

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 24

Accepted Solution

by:
Luciano Patrão earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

656 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