SQL 2000 tape backup fail

[A.Y. Xu]

Environment: Win Server 2003 Standard Version, SQL Server 2000, HP
DDS3 Tape(local).
Backup procedure:
1. open SQL Server Enterprise Manager
2. find the database i want to backup
3. right click and select "All Tasks"-"Backup Databse..."
4. Select "destination"-"backup to"-->>"Tape"
5. Click "Add", Select "Tape" device name(or may address)"\\.\Tape0"
6. Click "OK" begin to backup

Error:
system prompt:
The file on device '\\.\Tape0' is not a valid Microsoft Tape Format
backup set. BACKUP DATABSE is terminating abormally.

On this SAME server, using the same TAPE, but USE Tapeware(a HP backup
software come with HP tape machine) to back file, everything is OK.

I don't have any clue about this. am new to Windwos, new to SQL
server. Any body could show me light? Thanks in advance.

A.Y. From shanghai/China

[Dan Guzman]

Perhaps the tape needs to be formatted because it was previously used by
Tapeware. Select the 'overwrite existing media' and, under the options tab,
select 'initialize and label media.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"A.Y. Xu" <ay***@yahoo.com> wrote in message
news:bc**************************@posting.google.c om...

Environment: Win Server 2003 Standard Version, SQL Server 2000, HP
DDS3 Tape(local).
Backup procedure:
1. open SQL Server Enterprise Manager
2. find the database i want to backup
3. right click and select "All Tasks"-"Backup Databse..."
4. Select "destination"-"backup to"-->>"Tape"
5. Click "Add", Select "Tape" device name(or may address)"\\.\Tape0"
6. Click "OK" begin to backup

Error:
system prompt:
The file on device '\\.\Tape0' is not a valid Microsoft Tape Format
backup set. BACKUP DATABSE is terminating abormally.

On this SAME server, using the same TAPE, but USE Tapeware(a HP backup
software come with HP tape machine) to back file, everything is OK.

I don't have any clue about this. am new to Windwos, new to SQL
server. Any body could show me light? Thanks in advance.

A.Y. From shanghai/China

[AY Xu]

yah, I do formatted the tape use Tapeware with successfully. But SQL
Server backup with the same error. Maybe I need other software to format
the tape. The tape format which is formatted by other software may not
recognizable by SQL Server 2000.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dan Guzman]

Did you specify 'initialize' so that the tape is formatted during the SQL
Server backup? This will ensure the tape is in the Microsoft Tape Format
required by SQL Server backup.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"AY Xu" <ay***@yahoo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

yah, I do formatted the tape use Tapeware with successfully. But SQL
Server backup with the same error. Maybe I need other software to format
the tape. The tape format which is formatted by other software may not
recognizable by SQL Server 2000.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[AY Xu]

Thank you dan!
Solved! After select 'initialize and label media', the error gone. Thank
you.

I think SQL2000 dont recognize the format which is formatted by
Tapeware.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dan Guzman]

> I think SQL2000 dont recognize the format which is formatted by

Tapeware.
SQL Server requires MTF so it appears Tapeware doesn't use that format.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"AY Xu" <ay***@yahoo.com> wrote in message
news:41**********************@news.newsgroups.ws.. . Thank you dan!
Solved! After select 'initialize and label media', the error gone. Thank
you.

I think SQL2000 dont recognize the format which is formatted by
Tapeware.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Leythos]

In article <41**********************@news.newsgroups.ws>,
ay***@yahoo.com says...

Thank you dan!
Solved! After select 'initialize and label media', the error gone. Thank
you.

I think SQL2000 dont recognize the format which is formatted by
Tapeware.

You should still be doing the backup to disk and then a normal backup
from disk to tape.

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)