Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
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
- Posts: 1
- Joined: Mon Nov 26, 2012 6:06 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
Technical Support Engineer
- 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