PHWinfo - Afficher un message

03/04/2008, 16h05

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?

03/04/2008, 16h05	#3
Agho Messages: n/a Hébergeur:	RE: Backup/Restore Problem 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?