PHWinfo - Afficher un message

04/04/2008, 08h00

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?

04/04/2008, 08h00	#4
John Bell Messages: n/a Hébergeur:	RE: Backup/Restore Problem 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?