|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > SQL Server Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Lois Christianson 2002-10-30, 1:24 pm |
| I am getting an error 3266 on a backup operation. It says that
The Microsoft Tape Format soft filemark database on bakcup device 'Device
Name' cannot be read, inhibiting random access. SQLState 42000, Error 3266.
Backup or Restore operation terminating abmornmally. Error 3013. The step
failed.
Does anyone know where I can find ANY information on what the error code
means exactly? There is nothing in the documentation and I can't find
anything explaining exactly what the error means. We were able to create a
new device and it seems to work correctly, but at some point it stops
working with the above error code.
Please Help!!! Thanks in Advance
Lois Christianson
DBA FNIS
| |
| Russell Fields 2002-10-30, 2:23 pm |
| SQL Server 2000 Error 3266 from the BOL
The backup data in '%ls' is incorrectly formatted. Backups cannot be
appended, but existing backup sets may still be usable.
Although this is not the text your are getting, the problems seem related.
Your error seems to suggest that you were appending data to an existing
tape, but it could not find the mark to show it where to start.
This suggests an error in the way data is written to the tape. Are you
using a brand new tape? After creating a new device, does the failure occur
during the first backup, or only during attempts to append backups to the
tape? Are you able to restore the backup that is already on the tape?
I would check my tape media and tape drive. Both are fragile. (FWIW - Many
people have abandoned backing up directly to tape and back up to disk
instead. The backup files can be moved to tape as a later step.)
Russell Fields
"Lois Christianson" <lchristianson@fnis.com> wrote in message
news:OF5GbKEgCHA.456@tkmsftngp12...
> I am getting an error 3266 on a backup operation. It says that
>
> The Microsoft Tape Format soft filemark database on bakcup device 'Device
> Name' cannot be read, inhibiting random access. SQLState 42000, Error
3266.
> Backup or Restore operation terminating abmornmally. Error 3013. The
step
> failed.
>
> Does anyone know where I can find ANY information on what the error code
> means exactly? There is nothing in the documentation and I can't find
> anything explaining exactly what the error means. We were able to create
a
> new device and it seems to work correctly, but at some point it stops
> working with the above error code.
>
> Please Help!!! Thanks in Advance
>
> Lois Christianson
> DBA FNIS
>
>
| |
| Lois Christianson 2002-10-30, 3:23 pm |
| This is a disk file, not going to tape. Sorry I forgot to put this in.,
"Russell Fields" <rlfields@sprynet.com> wrote in message
news:e4agDxEgCHA.1676@tkmsftngp08...
> SQL Server 2000 Error 3266 from the BOL
>
> The backup data in '%ls' is incorrectly formatted. Backups cannot be
> appended, but existing backup sets may still be usable.
>
> Although this is not the text your are getting, the problems seem related.
> Your error seems to suggest that you were appending data to an existing
> tape, but it could not find the mark to show it where to start.
>
> This suggests an error in the way data is written to the tape. Are you
> using a brand new tape? After creating a new device, does the failure
occur
> during the first backup, or only during attempts to append backups to the
> tape? Are you able to restore the backup that is already on the tape?
>
> I would check my tape media and tape drive. Both are fragile. (FWIW -
Many
> people have abandoned backing up directly to tape and back up to disk
> instead. The backup files can be moved to tape as a later step.)
>
> Russell Fields
>
> "Lois Christianson" <lchristianson@fnis.com> wrote in message
> news:OF5GbKEgCHA.456@tkmsftngp12...
> > I am getting an error 3266 on a backup operation. It says that
> >
> > The Microsoft Tape Format soft filemark database on bakcup device
'Device
> > Name' cannot be read, inhibiting random access. SQLState 42000, Error
> 3266.
> > Backup or Restore operation terminating abmornmally. Error 3013. The
> step
> > failed.
> >
> > Does anyone know where I can find ANY information on what the error code
> > means exactly? There is nothing in the documentation and I can't find
> > anything explaining exactly what the error means. We were able to
create
> a
> > new device and it seems to work correctly, but at some point it stops
> > working with the above error code.
> >
> > Please Help!!! Thanks in Advance
> >
> > Lois Christianson
> > DBA FNIS
> >
> >
>
>
| |
| Tibor Karaszi 2002-10-31, 5:23 am |
| I would try deleting (copy away first, perhaps) the file and try again.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Lois Christianson" <lchristianson@fnis.com> wrote in message
news:OxFCqiFgCHA.1324@tkmsftngp11...
> This is a disk file, not going to tape. Sorry I forgot to put this in.,
> "Russell Fields" <rlfields@sprynet.com> wrote in message
> news:e4agDxEgCHA.1676@tkmsftngp08...
> > SQL Server 2000 Error 3266 from the BOL
> >
> > The backup data in '%ls' is incorrectly formatted. Backups cannot be
> > appended, but existing backup sets may still be usable.
> >
> > Although this is not the text your are getting, the problems seem related.
> > Your error seems to suggest that you were appending data to an existing
> > tape, but it could not find the mark to show it where to start.
> >
> > This suggests an error in the way data is written to the tape. Are you
> > using a brand new tape? After creating a new device, does the failure
> occur
> > during the first backup, or only during attempts to append backups to the
> > tape? Are you able to restore the backup that is already on the tape?
> >
> > I would check my tape media and tape drive. Both are fragile. (FWIW -
> Many
> > people have abandoned backing up directly to tape and back up to disk
> > instead. The backup files can be moved to tape as a later step.)
> >
> > Russell Fields
> >
> > "Lois Christianson" <lchristianson@fnis.com> wrote in message
> > news:OF5GbKEgCHA.456@tkmsftngp12...
> > > I am getting an error 3266 on a backup operation. It says that
> > >
> > > The Microsoft Tape Format soft filemark database on bakcup device
> 'Device
> > > Name' cannot be read, inhibiting random access. SQLState 42000, Error
> > 3266.
> > > Backup or Restore operation terminating abmornmally. Error 3013. The
> > step
> > > failed.
> > >
> > > Does anyone know where I can find ANY information on what the error code
> > > means exactly? There is nothing in the documentation and I can't find
> > > anything explaining exactly what the error means. We were able to
> create
> > a
> > > new device and it seems to work correctly, but at some point it stops
> > > working with the above error code.
> > >
> > > Please Help!!! Thanks in Advance
> > >
> > > Lois Christianson
> > > DBA FNIS
> > >
> > >
> >
> >
>
>
|
|
|
|
|