[dba-SQLServer]Restore from Command Line?

I have been looking at the SQLDMO library. It appears as if this approach
may be better. (I did sp_attach... several times yesterday, with some
questionable results, i.e. database is suspect messages afterwards from EM
and sure enough, no tables no nothing). 
The DMO stuff looks promising, but one question. Assume that on the
development box the db is stored say on e:\program files\Microsoft SQL
Server\...\data. Assume that it should be restored to the same dir but on
drive c:\. On looking through the DMO stuff, I can't readily see a property
which would override the "physical file" property that is stored with the
backup.
Any suggestions on how to deal with that? Are the physical file attributes
stored somewhere in the Restore object?
Arthur

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Francisco H
Tapia
Sent: February 28, 2003 4:06 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Restore from Command Line?

Then I would run a command from your Access ADP that connects to the MSDE
and does nothing else but that...

With CMD
    .Commandtext = "sp_attach ....
    'more code
End with

-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Arthur Fuller" <artful at rogers.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Friday, February 28, 2003 12:23 PM
Subject: RE: [dba-SQLServer]Restore from Command Line?


: I have assured that I can assume that MSDE is both installed and running.
: The real issue is how to restore the database without user intervention. I
: have been assured that on all target boxes the data directory and the MSDE
: installation will be identical (the defaults on drive c:). So I'm thinking
: that the tiny-Access-app with a call to sp_attach_db_single is the way to
: go....
:
: -----Original Message-----
: From: dba-sqlserver-admin at databaseadvisors.com
: [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Francisco H
: Tapia
: Sent: February 28, 2003 10:47 AM
: To: dba-sqlserver at databaseadvisors.com
: Subject: Re: [dba-SQLServer]Restore from Command Line?
:
: I have some SQL-DMO code lying around here that checks for a running
: instance of SQL (msde) and if the local box does not have it running it
: starts the service... I'll fish around for it today and forward it when I
: find it... in any case it "should" help you...as for a command line
: restore... I have not tried this but just a wag... using a batch file to
log
: into osql might be help out in this situation but of course this assumes
: that SQL (msde) is running already...
:
: -Francisco
: http://rcm.netfirms.com
: ----- Original Message -----
: From: "Arthur Fuller" <artful at rogers.com>
: To: <dba-sqlserver at databaseadvisors.com>
: Cc: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
: Sent: Friday, February 28, 2003 6:51 AM
: Subject: RE: [dba-SQLServer]Restore from Command Line?
:
:
: : I have searched BOL looking for this, so far without success. As I
: consider
: : the problem, however, a simple command-line restore may not solve it.
The
: : target machine is assumed to have a running instance of MSDE on it, but
: not
: : EM. I noticed that you cannot use the Access ADP backup and restore menu
: : options on this box. I may have to go the sp_attach_db route. I suppose
I
: : can whip up a very simple Access app that does nothing but exec
: sp_attach_db
: : and the filename.
: : Meanwhile, if you can give me a more accurate pointer to the BOL piece
you
: : meant, I'd appreciate it.
: :
: : -----Original Message-----
: : From: dba-sqlserver-admin at databaseadvisors.com
: : [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Djabarov,
: : Robert
: : Sent: February 26, 2003 12:22 PM
: : To: dba-sqlserver at databaseadvisors.com
: : Subject: RE: [dba-SQLServer]Restore from Command Line?
: :
: : bol
: :
: : ______________________________________________________
: : Robert Djabarov <http://web.usaa.com/profiles/profile.asp?EmplNum=52541>
: : Certified MS SQL Server DBA
: : Certified MS SQL Server Programmer
: : Certified MS VB Programmer
: : * (210) 913-3148 - phone
: : * (210) 753-3148 - pager
: :
:
<***************************************************************************
: : **********************>
: :
: :  -----Original Message-----
: : From: dba-sqlserver-admin at databaseadvisors.com
: : [mailto:dba-sqlserver-admin at databaseadvisors.com]  On Behalf Of Arthur
: : Fuller
: : Sent: Wednesday, February 26, 2003 10:37 AM
: : To: dba-sqlserver at databaseadvisors.com
: : Subject: [dba-SQLServer]Restore from Command Line?
: :
: : Can I restore a database from the command line (i.e. without any user
: : intervention)? The P&D wizard offers the option to execute any command
: once
: : installation is finished. The CD will contain a zip of a database
backup,
: : and I want to restore it to a known name without any user intervention.
: : TIA,
: : Arthur
: :
: :
: : _______________________________________________
: : dba-SQLServer mailing list
: : dba-SQLServer at databaseadvisors.com
: : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: : http://www.databaseadvisors.com
: :
:
:
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com
:
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com
:


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com