SDLT enough space..?

[kenjoswe]

Hi all,

I have a 136 GB database and for backup purpose I have a SDLT tape backup unit that can take 110/220 GB backup.
This means that the unit can take up to 220 GB compressed data. So, my question is: can the SQL-server 2000 backup program compress the data?

/Kent J.

 

[mrdenny]

No. You'd need to backup to disk then use a windows based app to backup the backup file to tape.

Or you can install a third party backup tool that supports backing up to tape with compression.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[Joeybear23]

Use hardware compression, which should be the default for the device anyway. It should fit fine when running SQL backups, but going to 1 drive will make it slow. If you send it to 2 simultaneously, your performance will double.

I have never used SDLT (I use DLT and LTO2 in my environment). So, some backup testing is probably in order for you.

SQL/SAP DBA

 

[kenjoswe]

OK!

I have change the backupdevice to HP Ultrium 230 -
80 meg/second according to the manual.
136 GB took 44 min = 52 meg/second.
I guess compression is connected to backupdevice and not to the SQL-server backup.

/Kent J.