Skip to main content

Hi , 

i try to perform a granular restore from a MS SQL  i‘ve  systematicallyt his error : “Granular restore is supported for blocklevel and snap backup. database selected doesn’t qualify for SQL granular restore

 

i enable block-level backup ( Optimized for File system with large number of small files (Block-LevelBackup  check box) in subclient.

i try with VSS and not. 

i checked prerequisites and all is done.

i missed soemthing ?

thanks for help

 

Hi @virgil - it sounds to me like you enabled block-level backups on the file system agent rather than the SQL agent (although happy to be wrong). Can you verify the following has been set:

  1. From the CommCell Console, click Client Computers > client > SQL Server > instance.
  2. Right-click a subclient > properties
  3. On the Advanced Options tab, select the Optimize for table level restore check box

 


hi Andre,

optimize for table retore is cheked ( sorry i copy/paste line from doc agent file )

Regards


Ok is done.

i reinstall SQL Agent and restart the server.

I see the table in the mount point but how to restore it in the original instance ?

i see just the proxy node in the field and is grayed out.

Thanks


Hi Virgil:

 

Have you reviewed and followed the doc sections for it:

https://documentation.commvault.com/commvault/v11_sp20/article?p=92238.htm

 

you will see:

“After you create a recovery point, you can restore the SQL tables to the same instance where the recovery point was created.”

 

Let me know if you have done this.


Reply