[Webinar] Streamline your web hosting managementRegister Today


Is there any problem having Backup Exec backup an SAP database across multiple tapes?

Posted on 2008-02-12
Medium Priority
Last Modified: 2013-12-08
Apologies if this is a no-brainer, this is data I can't play around with!

I have 7 different SAP servers that I backup and each goes to its own tape every night in its own full backup. We're about ready to add more servers and I can't keep allocating one server to its own tape. Some of these servers have as little as 30GB on them. I want to start using appends. Naturally, one of the backups will reach the end of the tape and start in on a new one. Is there any problem with this?

If there isn't, it seems that it would be an excellent time to use a policy to have one backup after another after another, etc.
Question by:secretmachine
  • 2
  • 2
LVL 23

Expert Comment

ID: 20877994

There is no problem with backups spanning to multiple tapes as long as the data is consistent. Coming to running one backup after the other to different tapes it would be better to run backup of two/three servers at a time unless it gives out a error or does not permit to backup three servers at a time.

If you want to schedule the backups one after the other i think that would be a problem as you can never anticipate the completion of a backup job as there might be lot of factors that might impact the backup window, so you cannot be certain that a particular backup will finish at a given time and the second will kick off.



Author Comment

ID: 20878249

That's pretty much what I wanted to know. In regards to backing up multiple servers at once... is that a feature in Backup Exec 10d or 11? That sounds great. We have two tape drives so I thought that meant I was limited to two servers at once. I'm trying to wrap my head around how that would work. If I have two backups that happen at the same time or in the same window that write to the same media set... does that do it?

At any rate, I'll give you the points for answering my question!
LVL 23

Accepted Solution

bhanukir7 earned 1000 total points
ID: 20878375

Where is the SAP database running i.e oracle on windows or linux. If it is on windows you can select the different windows servers in one job and run it to one tape and the rest of the servers to anothe tape.

The reason why i asked you to check if you are able to select multiple oracle database at the same in a single backup job is because sometimes it wont let you select oracle database if they reside on a same SAN disk.

So try to modify or create a new job and select the databases from two/three servers and submit the backup. This way you can minimize your tape requirement.
But you might need more number of tapes when you run a full backup or as your databases grow. Then you might consider purchasing a tape library for the backups.


Author Closing Comment

ID: 31430246

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Suggested Courses

608 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