Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 879
Iswanto San Avatar asked Dec 05 '25 03:12

Iswanto San


1 Answers

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.

like image 198
Yuliam Chandra Avatar answered Dec 07 '25 18:12

Yuliam Chandra