0

I have 134 separate databases on a SQL Server.

Every 15 minutes an entry appears in the msdb.dbo.backupset table for each database on the server.

  • Why does this happen every 15 minutes?
  • What is causing this to occur?
  • How do I stop these entries from happening?
  • Does anyone else see this type of activity on your MSDB database?
6

Backups for SQL Server can be scheduled in different way and we do not know how it is set up in your case.That is why we cannot tell you where to look. Most common scenarios are:

  • SQL Server Agent Job
  • Maintenance plan
  • 3rd party tool

If you run the script mentioned by @Kin in the comment section, it will show that your databases are most likely taking transaction log backup every 15 minutes.

If that is the case you also might want to purge your backup history periodically. You have to be careful on the first run as it might take very long depending on the amount of rows to be deleted and transaction log for MSDB can grow significantly. See the comments by Erik and Randi.

  • I've ran those queries mention by @Kin and they are type "D" databases. I know that most these databases are not being backup because they are static snapshots used only for reporting. There are twelve databases that are backed-up once a day through maintenance plans. This makes no sense to me whatsoever. Does anyone else see this kind of activity in there MSDB database? – Michael Riley - AKA Gunny Dec 20 '18 at 16:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.