Monday, February 20, 2012

MsSql Server 2000 Backup to tape

i have 3 schedule job for backing up different databases (4 database) to a
tape drive.
first job is to do database backup.
2nd job is to backup different database.
3rd job is to backup Transaction log database.
each job consist of 4 step, which each step is for each database
when schedule sometimes i get the message The file on device '\\.\Tape0' is
not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 3242)
Backup database is terminating abnormally. [ Sqlstate 42000](error 3013)
. the
step fail
but sometime it can go thru the job.
Please Help. Thanks
EHTanHi
Have you thought of changing to backing up to disc and then to tape?
John
"EngHim" wrote:

> i have 3 schedule job for backing up different databases (4 database) to a
> tape drive.
> first job is to do database backup.
> 2nd job is to backup different database.
> 3rd job is to backup Transaction log database.
> each job consist of 4 step, which each step is for each database
> when schedule sometimes i get the message The file on device '\\.\Tape0' i
s
> not a valid Microsoft Tape Format backup st.[Sqlstate 42000])error 324
2)
> Backup database is terminating abnormally. [ Sqlstate 42000](error 301
3). the
> step fail
> but sometime it can go thru the job.
> Please Help. Thanks
> --
> EHTan

No comments:

Post a Comment