Data Backup and Recovery

SMSQL schedules

benknights

Hi,

I've recently installed SMSQL 5.2 onto a number of SQL clusters. We're looking to have regular transaction log backups (hourly) and 3 daily full backups, one which also archives to SnapVault. The SV integration is all set up and ready to go, but i'm having trouble finding anywhere that documents how the schedules behave.

E.g. if i create the following

Fulls @ 00:00 (with archive to SV), 08:00, 16:00

Logs hourly from 00:00

At midnight I suspect both the Full and Logs backups will try to run...is SMSQL clever enough to sort this out for itself, or do i need to remove 00:00, 08:00 & 16:00 from the logs schedule?

Thanks,

Ben.

2 REPLIES 2

martin_fisher

Hi - In short, No, SMSQL isnt clever enough in that respect. Thomas is correct, if you have a full backup running at 00:00 and then a TXLog's job kicks in at the same time, the VSS writers will more than likely be locked by the full backup job. The scheduled task will still be running, so the 2nd task will find the writers locked and it will possible either fail straight away, or go into a retry state for a brief period. As its a full backup running, this will more than likely take a little while, with verification, so i would expect the TX logs job to fail or abort after a number of retries and try at its next scheduled time.

thomas_glodde

If i recall correctly, the 0:00 log backup will tell you that smsql is in use by another operation (full backup) and either retry or abort and redo at 1:00.

Announcements
Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

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