Why SQL 7 Server Enterprise Manager (SEM) backup to tape fails?

richtree
richtree used Ask the Experts™
on
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.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I have not work with Backup Exec, but you need to format the tape to SQL SERVER backup.

Please check in the Books Online the command BACKUP, there is an option to format the tape.

Author

Commented:
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?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial