Large SQL Backups

[lpollock]

I have a few SQL databases that are growing very large. One of them has reached almost 260GB in size. As it stands, it already takes the database about 12 hours to backup using Networker 7.1.2 writing to LTO-1 tape. Is there any way to use Legato to stripe this backup across more than one tape at a time? I'm looking for some way to speed this process up since I'm starting eclipse my backup window.

Any help is appreciated.

 

[Chacalinc]

yep, you can separate each db as separated savesets. Take a look to the sql module documentation.

example save set: MSSQL:$database (don't remember exactly the saveset)

cheers.

 

[lpollock]

That's the problem. I've already broken this SQL server down to the individual DBs. I have several databases on this box on one of them is 271 GB as of this morning. I have another on this save server that will potentially grow even larger than that.

Other than throwing gobs of extenal or SAN storage at it and backing up to disk, I'm not sure what my options are going forward with Legato.

 

[Chacalinc]

hmmm... ok, so your problem is the tape unit performance.. unfortunatelly, you can't break a saveset in order to back it up using more than 1 tape drive. (if my memory serves me, I remember you can backup by tables, so you could break a DB in tables)

so you need to replace it for a tape device with more speed or backup to disk. For backup to disk you can use ATA drives (cheaper than FC!).

 

[spaceball]

I'm not familar with SQL-Databases, we're using oracle db`s (our biggest is already close to 1TB) and right befor we implement SQL-Backtrack for DB Backups with Networker we used a self-develloped shell-script, switching the database tablespace-wise into backup-mode, backing them up and put them in endbackup again. so we were able to backup (close to) 1 TB DB with a parallelism of 9 streams onto a 9940b device in 8 to 10 houres. (now 6 houres with backtrack, also paralllelism of 9 sessions) So is it possible to toggle tablespacec in backup-mode?

Regards Spaceball