Our company's database is maintained offsite, and every night a backup is posted to an FTP server. I download the backup file and restore it to our local server each morning. I'd like to be able to set up the restore as a
scheduled task. I've tried doing it with a LOAD DATABASE command, but when I try to run the task and check the
history, I see that it has failed after one or two seconds. When I check the failure details I see the following message:

Database in use. System Administrator must have exclusive use of database to run load. (Message 3101)

I've tried stopping and restarting the MSSQL Server service on the server, but it doesn't fix the problem. I can also confirm that nobody is in the database at the time this is happening.