• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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.

0
richtree
Asked:
richtree
1 Solution
 
gpompeCommented:
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.
0
 
richtreeAuthor 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?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now