Q:

Difference between Tape and File In Backup Device

When I create a new Backup Devices in SQL Server Management Studio, I can choose the destination option, tape or file. What is the difference between both of that options?

A:

Back up to File (Disk) means you backup the database to hard drive.
Back up to Tape means you backup the database to tape drive.
It was disable, because the tape drive is not connected to your computer physically  or OS does not support the tape drive.

