Well, I guess no one else has replied, so I did this:

Alter Database AdventureWorks set offline
RESTORE DATABASE AdventureWorks
   FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\Backup\AdventureWorks.bak'
   WITH RECOVERY

I guess that works.  Thanks.

>I need to hand-move a DB backup file each day to an isolated network, and restore it. I want to automate this as much as possible. The DB on the isolated network is read only. I would like to use an Integrated Services Project to automate the restore process.
>
>What would be the best way to ensure that the DB is available for the restore (i.e. no one is connected to it). Would I use a SQL command to put it in single user mode, then put it back after (using the Alter database command)?
>
>All help is greatly appreciated.