How can we help you today? How can we help you today?

RESTORE errored out but still shows as trying to restore

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
Synergent
0

Comments

1 comment

  • 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
    chriskelly
    0

Add comment

Please sign in to leave a comment.