Redirected SQL restore fails with - A previous restore operation was interrupted and did not complete processing on file 'file_name'.

Problem

Redirected SQL restore fails with:

 

Error Message

V-79-65323-4319 - A previous restore operation was interrupted and did not complete processing on file 'file_name'. Either restore the backup set that was interrupted or restart the restore sequence.

 

Solution

The most common reason for this to occur is that the SQL server has run out of disk space but other reasons are possible.

  1. Free disk space on any disk containing a file in the filegroup mentioned in the error message, or if space is already available go to step 2.
  2. Reset the status by executing sp_resetstatus
  3. Run recovery by executing DBCC DBRECOVER

More information and alternatives are found in the article below:

msdn.microsoft.com/en-us/library/aa937568(v=sql.80).aspx

Note: DBCC DBRECOVER was removed from SQL Server 2012.

If the steps above do not resolve the issue, Microsoft should be contacted for assistance in correcting the issue with the SQL server.

 


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)