Solved

Oracle/SQL server transactional database backups using VEEAM

Posted on 2011-09-13
6
4,096 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 22

Expert Comment

by:Luciano Patrão
Comment Utility
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
Comment Utility
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 22

Expert Comment

by:Luciano Patrão
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:crazywolf2010
Comment Utility
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 22

Accepted Solution

by:
Luciano Patrão earned 500 total points
Comment Utility
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
Comment Utility
Thanks Jail. Let me do that and I will upload you a link if I see any solution there.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
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.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
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…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now