ou can use the MS SQL Server Management Studio and MS SQL Server Agent to backup directly to the tape media. Or you can use the MS SQL Server Agent with your tape backup program to stop the database, back up, and then restart the database. Or you can use the MS SQL Server Management Studio to schedule backups to a flat file. This flat file can then be backed up with your tape backup program. This file can be copied or backed up to another machine, as well.
Note: Many tape backup systems cannot effectively or directly backup MS SQL databases. If the MS SQL Server engine is running, the files that make up the database are locked open, and many tape systems cannot backup the locked database files from outside of the MS SQL Server Management Studio. These tape backup programs may see that the database files are open and skip the files.
Refer to the following:
MS SQL Server 2019