471,071 Members | 6,743 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

SQL 2000 tape backup fail

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
Jul 20 '05 #1
6 2934
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

Jul 20 '05 #2
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!
Jul 20 '05 #3
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!

Jul 20 '05 #4
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!
Jul 20 '05 #5
> 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!

Jul 20 '05 #6
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)
Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chirath Fernando | last post: by
reply views Thread by pjbr34 | last post: by
1 post views Thread by Akaketwa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.