Backup/Restore Problem

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 help?
http://msdn2.microsoft.com/en-us/library/aa238258(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:
[vbcol=seagreen]
> Hi
> Did you back this up to a tape or to disc?
> Does this help?
> http://msdn2.microsoft.com/en-us/library/aa238258(SQL.80).aspx
> John
> "TC" wrote:
|||Hi
If you back up locally you can run RESTORE VERIFYONLY to check it is ok
before moving it.
John
"Agho" wrote:
[vbcol=seagreen]
> I am having the same problem. I am backing it up to disk on another server.
> Thanks
>
> "John Bell" wrote: