Thanks for all your thoughts...

Could some one tell me why following error is coming..

The media family on device
'F:\datamart_feed_extract\datamart_feed_db_200308140658.bak' is incorrectly
formed. SQL Server cannot process this media family.

How we can deal with this situation? I am still trying to restore
thedata....

Thanks in advance...

> -----Original Message-----
> From: Tanesha Johnson-Bey [SMTP:[Email Address Removed] Sent: Monday, August 18, 2003 4:59 PM
> To: LazyDBA.com Discussion
> Subject: RE: Restore Databse
>
> Just in case the support article does not apply to you try this script.
> The script that you were using did not have a option to recover the
> database. Without the recovery option the database will open in read-only
> mode. Plug in the full pathnames where needed.
>
> restore database <type database name here>
> from disk = '<type the full path to the file being used for recovery>'
> with recovery,
> move '<type data file name>' to '<type the full path to the location of
> the data file>',
> move '<type log file name>' to '<type the full path to the location of the
> log file>'
> go
>
> Populated example below:
>
> restore database Northwind
> from disk = 'D:\MSSQL\BACKUP\Northwind_db_200308080115.BAK'
> with recovery,
> move 'Northwind' to 'D:\MSSQL\BACKUP\Northwnd.mdf',
> move 'Northwind_log' to 'D:\MSSQL\BACKUP\Northwind.ldf'
> go
>
> Tanesha
>
> >>> John Thomas <[Email Address Removed] 08/18/03 04:42PM >>>
> See if this applies to you:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q297104
>
> John
>
> -----Original Message-----
> From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed]
> Sent: Monday, August 18, 2003 1:13 PM
> To: LazyDBA.com Discussion
> Subject: RE: Restore Databse
>
> Now I am getting the New Error :
>
> Server: Msg 3241, Level 16, State 37, Line 1
> The media family on device 'd:\datamart_feed_db_200308171906.bak' is
> incorrectly formed. SQL Server cannot process this media family.
> Server: Msg 3013, Level 16, State 1, Line 1
> Backup or restore operation terminating abnormally.
>
> But now I can see the .MDF and .LDF files .. I used following query...
> Is
> there any way to fix the above error :
>
> Query :
>
> restore database Datamart_feed
> from disk = 'd:\datamart_feed_db_200308171906.bak' -- .bak file
> location
> with move 'datamart_feed_data' to 'd:\datamart_feed_Data.mdf', -- data
> files
> location
> move 'datamart_feed_log' to 'd:\datamart_feed_Log.ldf' --- log files
> location
>
>
>
> > -----Original Message-----
> > From: Julia Poddoubsky [SMTP:[Email Address Removed]
> > Sent: Monday, August 18, 2003 2:26 PM
> > To: 'Kaustubh Puranik'
> > Subject: RE: Restore Databse
> >
> > From Query Analyzer:
> >
> > restore database database_name
> > from disk = 'd:\***' -- .bak file location
> > with move 'database_data' to 'd:***.mdf', -- data files location
> > move 'database_log' to 'd:\***_log.ldf' --- log files location
> >
> >
> >
> > -----Original Message-----
> > From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed]
> > Sent: Monday, August 18, 2003 12:02 PM
> > To: 'Julia Poddoubsky'
> > Subject: RE: Restore Databse
> >
> >
> > Thanks Julia, Could you provide step by step details please ??
> >
> > > -----Original Message-----
> > > From: Julia Poddoubsky [SMTP:[Email Address Removed]
> > > Sent: Monday, August 18, 2003 1:58 PM
> > > To: 'Kaustubh Puranik'; LazyDBA.com Discussion
> > > Subject: RE: Restore Databse
> > >
> > > Yes, you can restore the file if your backup was not taken
> > off corrupted
> > > database .
> > > Use either Enterprise manager or restore from Query Analyzer
> > (check BOL).
> > >
> > > Julia
> > >
> > > -----Original Message-----
> > > From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed]
> > > Sent: Monday, August 18, 2003 11:54 AM
> > > To: LazyDBA.com Discussion
> > > Subject: Restore Databse
> > >
> > >
> > > Hi All,
> > >
> > > I am having the backup (.bak file) of my database. My existing
> > > databse is
> > > currupt and no longer exists into the enterprise
> > > manager/database. The .MDF
> > > and .LDF files are exists but are currupted. Is there any way
> > > to restore the
> > > database from .bak file. I never had this kind of problem
> > > before so please
> > > provide all details..
> > >
> > > Thanks a lot....
> > >
> > >
> ---------------------------------------------------------------------
> > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > To unsubscribe, e-mail: mssqldba-[Email Address Removed]
> > > For additional commands, e-mail: mssqldba-[Email Address Removed]
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed]
> For additional commands, e-mail: mssqldba-[Email Address Removed]
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed]
> For additional commands, e-mail: mssqldba-[Email Address Removed]
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page