PHWinfo - Afficher un message

28/03/2008, 09h41

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?

28/03/2008, 09h41	#2
John Bell Messages: n/a Hébergeur:	RE: Backup/Restore Problem 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?