We have an SQL Server 2K database that was approximately 198GB.
- This was backed up to an LTO1 tape drive (Dell PowerVault 110T) and fit on 1 tape - Done through SQL Enterprise Manager.
The database was reaching the full capacity of LTO1 tapes. We upgraded to an LTO2 drive (Dell PowerVault 122T Auto-loader) which has twice the capacity. (200gb native, 400gb compressed)
The database is now at around 203GB, and when we go to do a backup through Enterprise Manager the data has to be spanned across two LTO2 tapes. Im wondering why this is happening and can only guess that there is no hardware compression taking place?
It should easily fit onto 1 LTO2 tape, considering the database is only 5gb larger than when we were using LTO1. With the LTO2 it would get about 98% of the way thorugh the backup before asking for another tape.
I have spoken to Dell who could not recommend anything other than installing BackupExec SQL Agent..They also told me there are no options on the device itself to set any sort of configuration for this.
I know this is a bit borderline Hardware/SQL but i thought this would be a good place to start.
500 points for this one, its rather urgent to us