cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SQL 2008 Database Backup

Former Member
0 Kudos

Hi,

One of our client is taking the SAP SQL database backup using BRTOOL, backup happen on Standalone LTO 5.

They are taking backup of 1.4 TB in 1hr 30 Min.

I would like to know is it possible to achieve same as max write speed of LTO 5 in 140 MBPS, if we consider the are getting max throughput rate then too it should take around 3 hr 40 Min.

If it is possible then it would be grateful if someone can explain how.

Thanks & Regards

Mitt Gori

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi Mitt,

As your database is MSSQL not sure how you guys are using brtools ? It is meant for oracle database only.

You may use MSSQL Enterprise manager to schedule the backup or use db13.

Note: Requesting Moderator to shift this thread to MSSQL database.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

They use DB13 for backup, point is can we complete 1.4 TB backup in 1hrs 30 Min.

If yes then please explain me.

Regards

Mitt Gori

former_member188883
Active Contributor
0 Kudos

Hi Mitt,

It depends on I/O speed, LTO write speed , also how many parallel writes are being made to tapes.

If you say only single tape is being used for backup 1.4 TB of data, I am doubtful that it may get completed in 1hr 30 mins using traditional backup methods of SAP.

If you go with snapshot backup solutions then probably such timings can be made possible.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

HI Deepak,

That what bother us how this can happen they are not using snapshot based backup solution.

Can you through some light on how DB13 backup works.

Regards

Mitt Gori

former_member188883
Active Contributor
0 Kudos

Hi Mitt,

You may refer the details shared under thread Full Database Backup in DB13 for MS SQL Server ... | SCN on configuration of backups using db13 for MSSQL.

What it comes to my mind is ..

1) Can you check whether you have SSDs configured for the database

2) What is the Tape write speed.

Note: SSD disks can drastically improve the backup times as it has excellent read/write performance over SAS disk.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

Thanks for Link will go through it,they don't have SSD configured for database.

The max write seed for LTO 5 is 140 MBPS.

Thanks & Regards

Mitt Gori

former_member188883
Active Contributor
0 Kudos

Hi Mitt,

Without having SSD and with tape write speed of 150 MBPs, I am really not sure how they achieve backup time of 1hr 30 mins.

Is there any new technology for the disks which is much more faster than SSD ?

Regards,

Deepak Kori

Sriram2009
Active Contributor
0 Kudos

Hi Mitt

What is connectivity speed in between DB storage to standalone LTO5?

you can enhance the network speed from 1 to 10 g or / and fiber channel. to get the better throughput

Regards

Sriram

Former Member
0 Kudos

Hi Sriram,

DB storage and LTO 5 are connected through  8GB SAN switch.

Regards

Mitt

Matt_Fraser
Active Contributor
0 Kudos

I can't claim lots of familiarity with LTO 5 tape systems, but if it's max transfer speed is 150 MBps, then simple math says that if this is the slowest point in the transfer, the bottleneck, then in a perfect world a 1.4 TB backup would take at least 2.7 hours.  And, of course, we don't live in a perfect world, transfers are never consistently at the full speed, are they?  So, if they truly are getting something that is approximately half that time for a full backup, they must be writing to tape devices in parallel.

Regards,

Matt