Red Gate forums :: View topic - RESTORE errored out but still shows as trying to restore
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Backup 7
SQL Backup 7 forum

RESTORE errored out but still shows as trying to restore

 Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Synergent



Joined: 26 Nov 2012
Posts: 1
PostPosted: Mon Nov 26, 2012 6:09 pm    Post subject: RESTORE errored out but still shows as trying to restore Reply with quote
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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
PostPosted: Tue Nov 27, 2012 7:50 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group