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.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.