PROBLEM RESTORE [URGENT]

Mrs,

I'm having a serious problem while trying to restore a database backup. Before concluding the process, the following error apear's:

MICROSOFT SQL - DMO (ODBC SQLSTATE: 42000) The media family on device “d:\backup\dbprinc.bak” is incorrectly formed. This SQL Server cannot process media family. RESTORE DATABASE is terminating abnormally.

When I try “to attach” the database, the following message apear's: LOADING…. but the tables didn't open. I'll be grateful if somebody could help me, because I need to restore this database urgently.

Att.

Jess Augusto / Brazil

hope you are not restoring /attaching SQL Server 2005 database to SQL Server 2000 ... pse post the version and edition of the source and target

Madhu

|||

Sorry,

is Sql Server 2000 SP4.

Tanks

|||

The first message indicates that the file DBPRINC.BAK is not in the format of a TSQL backup. This could indicate that the file is corrupted or that it was produced by something other than TSQL backups.

I'm not sure why you would attempt to ATTACH a backup file.

Can you tell us how the file DBPRINC.BAK was produced? That will help us understand how to proceed.