Solved

Oracle/SQL server transactional database backups using VEEAM

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

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 22

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
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…
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …

773 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