If you missed the pre-registration for NetApp MS Azure AD B2C, the new login prompt will offer the option to register. Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Data Backup and Recovery

SMSQL schedules



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?





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.


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.

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