What are the challenges you face when working across database platforms? Take the survey
Options

RESTORE errored out but still shows as trying to restore

SynergentSynergent Posts: 2
edited November 27, 2012 1:50PM in SQL Backup Previous Versions
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

Comments

  • Options
    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
Sign In or Register to comment.