When you are using move option with recovery, u are forcing SQL Server to overwrite the existing
file.

Since your .mdf and .ldf files are corrupt, what you can do is to rename the .mdf and .ldf files
are move it to a different location and then try to do the restore.

--- Kaustubh Puranik <Kaustubh.[Email Address Removed] wrote:
> Yes it is the valid location.
> How can I force restore option?
> The size of the .bak file is 73206KB, Does it matter? I have 11 GB free
> space on drive D...
>
>
> > -----Original Message-----
> > From: Ganapathy S [SMTP:[Email Address Removed] > Sent: Monday, August 18, 2003 2:17 PM
> > To: LazyDBA.com Discussion
> > Subject: RE: Restore Databse
> >
> > Check if 'd:\mssql\data' is a valid location on the server where you are
> > trying to do the restore.
> >
> > -----Original Message-----
> > > From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed] > > Sent: Monday, August 18, 2003 2:10 PM
> > > To: LazyDBA.com Discussion
> > > Subject: RE: Restore Databse
> > >
> > >
> > > 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] > >
> > > ---------------------------------------------------------------------
> > > 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] > >
> >
> >
> > =====
> > Ganapathy Sankara Baaham
> > 60 Strawberry Hill Ave
> > Stamford CT USA
> >
> > If u can dream it,
> > you can do it.
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> >
> > ---------------------------------------------------------------------
> > 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] Sankara Baaham
60 Strawberry Hill Ave
Stamford CT USA

If u can dream it,
you can do it.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page