problem with RESTORE database

Hi Friends,
I have been facing a problem while restoring a database backup from
one SQL server on Win2003Server to another SQL Server on Win2000.
The error head is
ODBC SQL STATE : 42000
Please suggest me some way to overcome this.
Thanks,
Dutt.
How exactly are you restoring the database and can you give the full error
please?
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173694572.447609.52340@.h3g2000cwc.googlegrou ps.com...
> Hi Friends,
> I have been facing a problem while restoring a database backup from
> one SQL server on Win2003Server to another SQL Server on Win2000.
> The error head is
> ODBC SQL STATE : 42000
>
> Please suggest me some way to overcome this.
> Thanks,
> Dutt.
>
|||yeah,
Its saying........
The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
SQL Server cannot process this media family.
RESTORE is terminating abnormally.
Thanks Immi,
Dutt
|||and you are getting this error from simply backing up the database, copying
to the new server and then restoring?
Are they both SQLserver 2005?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:O7AVESJZHHA.3628@.TK2MSFTNGP02.phx.gbl...
> How exactly are you restoring the database and can you give the full error
> please?
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1173694572.447609.52340@.h3g2000cwc.googlegrou ps.com...
>
|||Dutt
Try
restore database ... from disk ='D:\Xpert_Full.bak' with file=1 ,recovery
I think you issued your backup with 'without init' option
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegro ups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>
|||Hello,
Can you use RESTORE HEADERONLY and see if you have multiple backup files in
the same the same backup file. If yes then
try using FILE= option while restoring. If you get any errors then you may
need to contact microsoft product support to
investigate further or do a FULL database backup again from source using
BACKUP DATABASE WITH INIT option
and try restoring into destination again.
Thanks
Hari
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1173697414.376193.158530@.h3g2000cwc.googlegro ups.com...
> yeah,
> Its saying........
> The media family on device 'D:\Xpert_Full.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> RESTORE is terminating abnormally.
> Thanks Immi,
> Dutt
>
|||Hi,
Immy,I'm using SQL Server 2000 in both systems.
Dimant,Its showing some error.
Hari,There is only one backup with that name.
I stress again that the back up is in another server.
Thanks,
Dutt