Data Backup and Recovery Discussions

Snapcenter SQL backup types

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

 

Forums