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
· Share on Twitter

Comments

  • Options
    chriskellychriskelly Posts: 378
    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
    · Share on Twitter
Sign In or Register to comment.