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.