Skip to main content
Solved

Restoring SQL DB from Azure-Archive

  • 17 November 2022
  • 3 replies
  • 161 views

Forum|alt.badge.img+13

Hi Team, 

 

Greetings! 

We are trying to restore the DB from our azure-archive blob, and it is getting failed. i checked the logs and can see below error in it. is it something to do with commvault / azure end. 

 

4064  17b8  11/16 16:05:17 267160 [cvd] ReadFile() - failed to read the remote file - K0P72A_Folder1/CV_MAGNETIC/V_16918/CHUNK_910913/SFILE_CONTAINER_022, error:  Message: This operation is not permitted on an archived blob.
RequestId:b07cc10c-d01e-0031-1007-fac083000000
Time:2022-11-16T22:05:17.4193091Z
4064  6d4   11/16 16:05:17 267160 [cvd] ReadFile() - failed to read the remote file - K0P72A_Folder1/CV_MAGNETIC/V_16923/CHUNK_911089/SFILE_CONTAINER_001, error:  Message: This operation is not permitted on an archived blob.
RequestId:ba057d1e-e01e-00f1-6207-fa38bd000000
Time:2022-11-16T22:05:17.5051812Z
 

Best answer by Mike Struening RETIRED

Hi @Allan0105 , hope all is well!  My initial thought here is that you have to recall the blobs from the cold storage (on the azure side).

Before we go into a few case resolutions, I found, I wanted to share this link about restores for archived cloud storage to ensure you’re following the process.

https://documentation.commvault.com/11.26/expert/102379_performing_on_demand_recalls_from_archive_cloud_storage.html 

Now, if the above is already being done, then I have some possible fixes:

I saw an incident with that message.  It was due to a Lifecycle Policy set on the cloud, which was automatically rearchiving the items based on age as soon as the recall completed.

In another (might not be applicable) the database was part of an AppWare job and the entire VSA needed to be restored for it to complete.

If none of this applies, let me know though you’re likely best suited for a support case due to the large number of factors.

View original
Did this answer your question?

3 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

Hi @Allan0105 , hope all is well!  My initial thought here is that you have to recall the blobs from the cold storage (on the azure side).

Before we go into a few case resolutions, I found, I wanted to share this link about restores for archived cloud storage to ensure you’re following the process.

https://documentation.commvault.com/11.26/expert/102379_performing_on_demand_recalls_from_archive_cloud_storage.html 

Now, if the above is already being done, then I have some possible fixes:

I saw an incident with that message.  It was due to a Lifecycle Policy set on the cloud, which was automatically rearchiving the items based on age as soon as the recall completed.

In another (might not be applicable) the database was part of an AppWare job and the entire VSA needed to be restored for it to complete.

If none of this applies, let me know though you’re likely best suited for a support case due to the large number of factors.


Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Vaulter
  • 1207 replies
  • November 17, 2022

Relevant meme :)

The workflow @Mike Struening mentioned is required to recall the archive data before it can be restored. It can be setup to automatically run, but it has to be configured first. The docs should guide you through the process

 

 


Forum|alt.badge.img+13
  • Author
  • Byte
  • 115 replies
  • November 30, 2022

Thanks Mike & Damian , once the storage recall completed, restore is working fine. 


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