Thanks...

When I tried it I got following Error :
================================
Server: Msg 3156, Level 16, State 2, Line 1
The file 'd:\mssql\data\datamart_feed_Data.mdf' cannot be used by RESTORE.
Consider using the WITH MOVE option to identify a valid location for the
file.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

The restore statement is :
=====================
Restore database Datamart_feed
from disk = 'd:\datamart_feed_db_200308171906.bak'
with recovery,
Move 'datamart_feed_Data' to 'd:\mssql\data\datamart_feed_Data.mdf',
Move 'datamart_feed_Log' to 'd:\mssql\data\datamart_feed_Log.ldf'



> -----Original Message-----
> From: Mitchem, Jim [SMTP:[Email Address Removed] Sent: Monday, August 18, 2003 2:02 PM
> To: LazyDBA.com Discussion
> Subject: RE: Restore Databse
>
> Edit the below to use your existing file/database name and file
> locations. This will restore your database from your backup. Keep in
> mind your database will be restored up to the date and time of your
> backup. Any activity that occurred after the backup will be lost.
>
> -- login as SA use master
> Restore database mydatabase
> from disk = 'd:\mssql\backup\mydatabase.bak'
> with recovery,
>
> Move 'mydatabase_Data' to 'd:\mssql\data\mydatabase_Data.mdf',
> Move 'mydatabase_Log' to 'd:\mssql\data\mydatabase_Log.ldf'
>
> -----Original Message-----
> From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed]
> Sent: Monday, August 18, 2003 2:54 PM
> 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]MS Sql Server LazyDBA home page