Why SQL 7 Server Enterprise Manager (SEM) backup to tape fails?
Posted on 2006-10-20
I have SQL 7 server (SP4) running on NT 4 server (SP6).
There is tape drive in it.
I used to use Backup Exec 8.5 to do backup, meaning tape drive and tape should be OK.
Now Backup Exec 8.5 is removed.
When I use SEM to back up a database to the tape, I stopped with the following error:
"The media family on device \\.\Tape0 is incorrectly formed. SQL Server cannot process this media family.
Backup or restore operation terminating abnormally."
Q#1: Does it mean Backup Exec formats the tape differently than SEM?
Q#2: How to format the tape in SEM manually?
Thank you for sharing your knowledge.