[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