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

Article:TECH204339  |  Created: 2013-03-26  |  Updated: 2013-04-05  |  Article URL http://www.symantec.com/docs/TECH204339
Article Type
Technical Solution


Subject

Issue



Redirected SQL restore fails with:

 


Error



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.

 


Supplemental Materials

SourceUMI
Valuev-79-65323-4319
Description

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.

 



Article URL http://www.symantec.com/docs/TECH204339


Terms of use for this information are found in Legal Notices