Problems With Automated Jobs

Hi guys

I have setup a sequence of jobs to run maintenance on one of our SQL Servers.

The sequence of jobs is as follows:

Backup database
Archive database
Recreate indexes
Shrink database
Update statistics
Backup database

There is also another step which is Restore Database. This step is only called if the Archive, Re-index or Shrink jobs fail.

I made a slight script error and so when the job ran on Sunday it deemed the job a failure and attempted to restore the database, that wasn't a problem as the error was deliberate to test the restore process.

The restore process failed and logged the following message:

Job 'Sunday Maintenance - Full' : Step 8, 'Restore Database' : Began Executing 08/02/04 22:58:40

Msg 3101, Sev 16: Database in use. The system administrator must have exclusive use of the database to run the restore operation. [SQLSTATE 42000]
Msg 3013, Sev 16: Backup or restore operation terminating abnormally. [SQLSTATE 42000]

The syntax I used to do the restore was:

RESTORE DATABASE Emvolve
FROM DISK = 'H:DbdataBackupEmvolve_Full_Before.BAK'
WITH REPLACE

How do I get around this error message to complete the restore automatically? Any services that access this database are stopped prior to this process running so nothign should be accessing SQL.

Any ideas would be appreciated as I am only a learner as far as SQl goes.

Cheers

Paul


:)