August 1, 2001 at 10:13 am
Is it possible to set SQL 7 up to use an autoloader tape drive? I've managed to set up a tape device on one of our SQL installs with a single DLT drive which works fine, but I can't seem to make it talk on the server with a 7 slot autoloader DLT drive.
Thanks in advance.
Robert Elmes
August 1, 2001 at 10:08 pm
Not sure why it would make a difference. Are you going to back up directly to tape, or to disk first and from there to tape? Just out of curiousity, what kind of dlt drive and is it on the HCL?
Andy
August 2, 2001 at 3:18 am
I am trying to get SQL to backup directly to the Tape.
The drive is a Quantum DLT7000 and it is on the HCL.
Currently we use Backup Exec 8.5 on that server and it works fine - but I'm trying to do an automated Backup & then redirected restore and it isn't possible to automate it with Backup Exec. I've worked out how to do it with SQL backup - but can't get that to talk to the tape drive.
Rob
August 2, 2001 at 2:48 pm
If you've got the space, you could write the backup to disk, move it over, then restore it. Quite a few of us have our SQL Server backups being written to disk and being backed up from the file perspective, rather than allowing a backup software use a SQL agent to try and get a SQL Server backup.
K. Brian Kelley
K. Brian Kelley
@kbriankelley
August 2, 2001 at 4:07 pm
You have to use something like Veritas or arcserve to control the tape library autoloader features. SQL doesn't have a way to rotate out tapes that I know of. I could be wrong, I have been before :). I do dumps to disk then send them to a single server and then back that up to disk.
August 2, 2001 at 4:45 pm
From Dells web site on SQL disaster recovery:
More sophisticated and expensive third-party backup tools provide enhanced functionality, such as full autoloader and tape library
support. However, Enterprise Manager in SQL Server 2000 Enterprise provides capabilities that should satisfy many database requirements in small-to-medium-complexity data centers.
So no autoloaders not supported by sql backup.
Wes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply