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]MS Sql Server LazyDBA home page