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]

MS Sql Server LazyDBA home page