I have a SQL 2000 Server that I want to create a test version of a database
on another SQL 2000 server. After creating a backup (database – complete) of
the desired database and attempting a restore on a dev server (creating a new
db name on the dev server), it fails with a consistency error. The log
contains the following message: 3266 :The backup data in 'D:\PPTest' is
incorrectly formatted. Backups cannot be appended, but existing backup sets
may still be usable. I have run dbcc checkdb checks on the source db and
they seem ok. Any ideas why I am getting this error on the restore?

Hi

Did you back this up to a tape or to disc?

Does this ?
http://msdn2.microsoft.com/en-us/lib...8(SQL.80).aspx

John

"TC" wrote:

> I have a SQL 2000 Server that I want to create a test version of a database
> on another SQL 2000 server. After creating a backup (database – complete) of
> the desired database and attempting a restore on a dev server (creating a new
> db name on the dev server), it fails with a consistency error. The log
> contains the following message: 3266 :The backup data in 'D:\PPTest' is
> incorrectly formatted. Backups cannot be appended, but existing backup sets
> may still be usable. I have run dbcc checkdb checks on the source db and
> they seem ok. Any ideas why I am getting this error on the restore?

I am having the same problem. I am backing it up to disk on another server.

Thanks


"John Bell" wrote:

> Hi
>
> Did you back this up to a tape or to disc?
>
> Does this ?
> http://msdn2.microsoft.com/en-us/lib...8(SQL.80).aspx
>
> John
>
> "TC" wrote:
>
> > I have a SQL 2000 Server that I want to create a test version of a database
> > on another SQL 2000 server. After creating a backup (database – complete) of
> > the desired database and attempting a restore on a dev server (creating a new
> > db name on the dev server), it fails with a consistency error. The log
> > contains the following message: 3266 :The backup data in 'D:\PPTest' is
> > incorrectly formatted. Backups cannot be appended, but existing backup sets
> > may still be usable. I have run dbcc checkdb checks on the source db and
> > they seem ok. Any ideas why I am getting this error on the restore?

Hi

If you back up locally you can run RESTORE VERIFYONLY to check it is ok
before moving it.

John

"Agho" wrote:

> I am having the same problem. I am backing it up to disk on another server.
>
> Thanks
>
>
> "John Bell" wrote:
>
> > Hi
> >
> > Did you back this up to a tape or to disc?
> >
> > Does this ?
> > http://msdn2.microsoft.com/en-us/lib...8(SQL.80).aspx
> >
> > John
> >
> > "TC" wrote:
> >
> > > I have a SQL 2000 Server that I want to create a test version of a database
> > > on another SQL 2000 server. After creating a backup (database – complete) of
> > > the desired database and attempting a restore on a dev server (creating a new
> > > db name on the dev server), it fails with a consistency error. The log
> > > contains the following message: 3266 :The backup data in 'D:\PPTest' is
> > > incorrectly formatted. Backups cannot be appended, but existing backup sets
> > > may still be usable. I have run dbcc checkdb checks on the source db and
> > > they seem ok. Any ideas why I am getting this error on the restore?