Skip to main content
Solved

MS SQL Granular restore

  • 26 January 2021
  • 4 replies
  • 2113 views

Forum|alt.badge.img+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

 

Best answer by Peter_C

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.

View original
Did this answer your question?

4 replies

Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Vaulter
  • 1229 replies
  • January 26, 2021

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

 


Forum|alt.badge.img+8
  • Author
  • Byte
  • 45 replies
  • January 27, 2021

hi Andre,

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

Regards


Forum|alt.badge.img+8
  • Author
  • Byte
  • 45 replies
  • February 3, 2021

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


Forum|alt.badge.img
  • Vaulter
  • 3 replies
  • Answer
  • February 3, 2021

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.


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