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' 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
> --
> EHTan

No comments:

Post a Comment