[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