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

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.
secretmachineAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bhanukir7Commented:
Hi,

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.

bhanu

0
secretmachineAuthor Commented:
Bhanu,

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!
0
bhanukir7Commented:
Hi,

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.

bhanu
bhanu
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
secretmachineAuthor Commented:
excellent
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.