RESTORE errored out but still shows as trying to restore

Synergent

How can I stop the Restoring message from showing on a failed attempt

The RESTORE failed due to storage requirements.

I've stop the SQL backup agent service but the message persists

chriskelly

Assuming that the database can be brought online and is in a state that is usable, then the following t-sql query will do so.

RESTORE DATABASE <databasename> WITH RECOVERY