Skip to main content
Solved

MS SQL GRANULAR RESTORE

  • 10 February 2021
  • 4 replies
  • 610 views

Forum|alt.badge.img+8

Hi,

Can we restore table to the same database with granular restore option ?

Regards

Best answer by Mike H

Hi Virgil, 

No you cannot restore the a table back to the same DB.

Recovering SQL Tables from a Recovery Point (commvault.com)

“When you restore from a recovery point, you save time because the snap mount is complete and the database is already attached. Table restore is not allowed to the database created from the recovery point job.”

 

View original
Did this answer your question?

4 replies

MichaelCapon
Vaulter
Forum|alt.badge.img+14
  • Vaulter
  • 349 replies
  • February 10, 2021

Hi Virgil,

 

I believe that Granular Restore for MS SQL can only be done with BlockLevel and IntelliSnap or AppAware backups.

-If you aren’t using the above methods then you will see an error on Granular Browse stating the DB doesn’t qualify.

 

Regards,

Michael


Forum|alt.badge.img+6
  • Vaulter
  • 40 replies
  • Answer
  • February 10, 2021

Hi Virgil, 

No you cannot restore the a table back to the same DB.

Recovering SQL Tables from a Recovery Point (commvault.com)

“When you restore from a recovery point, you save time because the snap mount is complete and the database is already attached. Table restore is not allowed to the database created from the recovery point job.”

 


Damian Andre
Vaulter
Forum|alt.badge.img+23
  • Vaulter
  • 1235 replies
  • February 10, 2021
Mike H wrote:

Hi Virgil, 

No you cannot restore the a table back to the same DB.

Recovering SQL Tables from a Recovery Point (commvault.com)

“When you restore from a recovery point, you save time because the snap mount is complete and the database is already attached. Table restore is not allowed to the database created from the recovery point job.”

 

To clarify, this seems to indicate you can’t restore back to the temporarily mounted database (snap mount) that is instantiated by the recovery operation - but you should be able to restore back to the database from where the backup originated on the production server?


Forum|alt.badge.img+14

No, you cannot restore to the original database that you are browsing.

This is also being discussed on this thread.

Granular Table Restore to original database

I will update with complete details or possible CMR.


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