RESTORE errored out but still shows as trying to restore

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

RESTORE errored out but still shows as trying to restore

Postby Synergent » Mon Nov 26, 2012 6:09 pm

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
 
Posts: 1
Joined: Mon Nov 26, 2012 6:06 pm

Postby chriskelly » Tue Nov 27, 2012 7:50 pm

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
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests