Solved

MS SQL Granular restore

  • 26 January 2021
  • 4 replies
  • 1870 views

Userlevel 2
Badge +8

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

 

icon

Best answer by Peter_C 4 February 2021, 00:18

View original

4 replies

Userlevel 7
Badge +23

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

 

Userlevel 2
Badge +8

hi Andre,

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

Regards

Userlevel 2
Badge +8

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

Userlevel 1
Badge

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