Skip to main content
Question

Sql Restoration failing

  • February 22, 2024
  • 1 reply
  • 204 views

Forum|alt.badge.img+2

Hi Team,

We have daily schedule for SQL restore and some times  SQL restoration job is going to pending state with below error. Could you please help on this.

 

Query Result [Microsoft.SqlServer.Management.Common.ExecutionFailureException:A previous restore operation was interrupted and did not complete processing on file 'ENDR_MSS_DATA'. Either restore the backup set that was interrupted or restart the restore sequence. Problems were identified while planning for the RESTORE statement. Previous messages provide details. RESTORE DATABASE is terminating abnormally. An exception occurred while executing a Transact-SQL statement or batch.].
Source: vmcwendrqdb03, Process: SQLRestore

1 reply

Forum|alt.badge.img+14

Hello @Tyson Storage Team 

If you right click the Restore Job > View > Logs, search for CVD.log from the MediaAgent performing the restore. Do you see any errors in that log about not being able to read the data?

 

Thank you,
Collin


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings