Data Backup and Recovery

SnapCenter SQL takes long to backup

Nick4704
2,062 Views

Hi

 

Sometimes, pretty frequently, backups of SQL DBs take around 10-20 minutes to complete with time spent in "Registering Backup and Applying Retention".

Because of 15min log backup schedule, jobs are beeing queued.

Can anybody tell what happens in that "Registering Backup and Applying Retention" phase and what can be the reason for long processing???

SnapCenter CPU utlization (4 cores, virtual machine) is around 40-50% taken by IIS worker mostly.

Thank you

 

Nick.

 

SnapCenter 4.0P1

2 REPLIES 2

matte
2,048 Views

Hi

"Registering Backup and Applying Retention" means store the metadata information of the backup on the SnapCenter database and then apply the retention by deleting backups and snapshots accordingly. So, or the comunicaiton with the database has some problme or you have a large number of backups/snapshot to check if they need to be deleted.

Do you see some timeout or failure or the prcess in the end succeeds?

You can try by configuring the appropriate retention and running the PS cmdlet "Remove-Smbackup -CleanupSecondaryBackups" regularly to cleanup the metadata entries

Nick4704
2,028 Views

Hi

I see that some jobs are not being queued because queue is full. But jobs complete ok, no error messages, no timeouts. Just it takes 10min to register backup.

Retention/schedule is a business requirement.

We don't have SnapVault and retention setting looks work ok.

Any ideas how can I check where it spends those 10minutes?

Тшсл

Public