Remote Tape Backup Device on SQL Server

[Jasper]

Does anyone know if it is possible to have a tape device another server as a tape dump device on SQL. Instead on removing the tape drive and installing it locally ?!?

Regards

Jasper

[Don Romano]

According to SQL Server Books OnLine:

"About Disk Dump Devices:
SQL Server supports both local and network disk dump devices. A local disk dump device is created on a disk drive attached to the local computer. A network disk dump device is created on a shared network directory.
:
:
About Tape Dump Devices:
SQL Server supports local tape dump devices (on tape drives attached to the local computer). Network tape dump devices are not supported."

Therefore, it appears that the answer is no. If you want to use that tape device you will need to install in locally or do a backup to a disk device and then backup that disk device to tape remotely.

Don

On 8/7/98 3:23:35 AM, Jasper wrote:
> Does anyone know if it is possible to have a tape device another server as
> a tape dump device on SQL. Instead on removing the tape drive and
> installing it locally ?!?

Regards

Jasper

[Steve Oldridge]

To the best of my knowledge, SQL Server does NOT support remote tape backup, and only supports local deices.

However, there is a way to do this !! (at least on NT)
Arcserve Enterprise Edition (using SQL Server backup agent) will backup and restore any SQL Server database on the network - given appropriate security equivalences on the machine / database.

Steve Oldridge
Consultant