richtree
asked on
Why SQL 7 Server Enterprise Manager (SEM) backup to tape fails?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Any idea what's wrong and how to fix it?