Skip to main content
Question

MS SQL Instant Clone / Recovery Points - how it works

  • August 4, 2026
  • 0 replies
  • 4 views

mateusznitka
Apprentice
Forum|alt.badge.img+7

Hi,

Can someone clarify the Instant Clone or “Optimize for table level restore” features?

I have multiple SQL Servers. DB admins ask me about possibility to restore single tables instead of whole databases (some of them are huge like 10+ TB).

So now I’m testing this on my playground but I’m not sure I get how it works.

Creating recovery point / instant clone attach new database to selected instance and on low-level this is VSS snapshot mounted directly from my Commvault disk library to the proxy server. So there is no real data on server - it’s just on my commvault library. Is that correct?

Proxy server have to be the server when I have target instance.

I can’t restore tables directly to the source database. I can only restore tables to some another databases. So what is the point of this feature?

I saw that enabling this cause backup by only 1 stream. Is that true?