Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

backup to tape fails help!!!

backup to tape fails help!!!

backup to tape fails help!!!

Hi all,
I have a sql agent job that is failing and I cannot figure out why? I'm trying to backup a database to tape and during the verify backup process it termintes wit an error code. I'm pasting the backup and verify backup steps carried out by sql agent below. Any help will be appreciated.


[1] Database model: Transaction Log Backup...
Destination: [\\.\Tape0]

** Execution Time: 0 hrs, 19 mins, 28 secs **

[2] Database model: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3143: [Microsoft][ODBC SQL Server Driver][SQL Server]The data set on device '\\.\Tape0' is not a SQL Server backup set.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.

RE: backup to tape fails help!!!


Could you change your job to backup to a disk device and then schedule a job to back your backup to the tape device. I thiunk this should work.


RE: backup to tape fails help!!!

Thanks for your reply calahans. I could certainly do what you're suggesting. I guess I was just trying to eliminate an extra step. Another piece of info that might help, in the Management/Backup window, if I click on the backup device (Tape1 in my case), and view properties and then view the contents of the tape, the backups are there.

RE: backup to tape fails help!!!

Hi Abashir,

Have you tried to back up from your backup set to a test database. Maybe your backups are working you are just getting an error. I have had problems with devices which are not disks (i.e. tapes), but we where able to get a restore in the end.

Also, I appreciate that you don't want the extra step, however if you backup over the same disk device each day it won't take much room. Then restore to differing tapes each day.

One last thing - I notice its the model database you are having trouble with - this is not a particularly important database. The model database is used as a template for any new database you create. You don't need to back it regularly (UNLIKE THE MASTER DB!)



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close