Link to home
Start Free TrialLog in
Avatar of richtree
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.

ASKER CERTIFIED SOLUTION
Avatar of gpompe
gpompe

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of richtree
richtree

ASKER

When I open NTBackup utility, "Format tape" menu is greyed out. When I choose "Hardware setup" menu, it recognize the tape drive. But when I choose it and click OK, it shows "the tape drive is busy".
Any idea what's wrong and how to fix it?