BrightStor SQL Backup is longer than VLDB? 1

[backupfrank]

I have move recently my database VLDB to SQL 2000. The differential backup and the full backup are taking much more time (about 15 hours more). The SQL server is not the same server has the backup server.What is the way improve the time of the backup?
Multiplexing?
My equipement IBM LTO with 30 Tapes, 2 head, Windows 2000 SP4, BrightStor V11 SP1
Thank you.

 

[backupfrank]

Multiplexing have reduce de time from 22 hours to 6 hours.
But it's still longer than when i had a VLDB database instead of SQL. About 3 hours total for the differential backup. Any sugestions will be appreciate.

 

[jmcasane]

What Remain capacity appear in the log?
I'm afraid the Multiplexing jobs doesn't works well in this way.

jmc

 

[backupfrank]

Could you tell me why it's a problem? Remain capacity is always 0 MB??
Exemple :
Information 01/18/2005 07:29:29 PM 17 *** Backup Summary for Job ID 17 ***
Information 01/18/2005 07:29:28 PM 17 Media Compression Ratio : 0.00
Information 01/18/2005 07:29:28 PM 17 Media Remaining Capacity : 0 MB
Information 01/18/2005 07:28:26 PM 21
Thank you.

 

[jmcasane]

Always that you run a MUX backup, the Remain capacity that you can see in the log is 0 MB

You can run the same job without MUX and see the right Remain capacity of the tape.

I think it's a mistake. I've submited this to CA.

jmc

 

[backupfrank]

Thank you jmcasane, i hope CA have a solution for the remain capacity 0MB. If you know informations or you have a contact about reduce the backup time with a SQL database, please send me theses informations. I need to learn to good practices with a SQL database instead of a VLDB database. For example do you still need to make a DBPRUNING?
A+