Data Backup and Recovery

Snapcenter SQL backup types

Nick4704

Hi

 

Can anybody explain for a dummy what are Snapcenter 4.0 SQL backup types (Full and Logs, Full, Logs)?

When does log truncation happen?

Is it enough to make Full Backup to have restoreable SnapVault destination?

 

Correct me if I'm wrong:

 

1. Full and Logs

-Creates snapshots for data and log volumes. Rotates Snapshots.

-Copies Logs to Host Log Directory and creates a snapshot for Host Log Directory volume (aka snapinfo)

-Truncates logs (deletes logs in log volume)

-Deletes old Log files in HLD (according to retention)

 

2. Full

-Creates snapshots for data and log volumes. Rotates Snapshots

-Deletes old Log files in HLD (according ro retention)

-DOES NOT truncates logs

 

3. Log backup

-Copies Logs to Host Log Directory and creates a snapshot for Host Log Directory volume (aka snapinfo)

-Truncates logs (deletes logs in log volume)

-DOES NOT delete (rotate) snapshots

 

During restore Snapcenter uses recent Full or Full and Log backup, then looks at HLD to restore Up To Minute... it actually does not use Log volume for log roll?!

 

Thank you

Nick

 

0 REPLIES 0
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public