How are SQL Server backups being run?

We have SQL Server 2016.
In SSMS, looking at the canned report for Backup and Restore Events - Successful Backup Operations, I see that one of our databases is being backed up every morning at 0300. The average size is 4.56 GB and the average time is .17 minutes. The device type Is 7.

The System Agent only shows two jobs, neither associated with backups.

Does this indicate that the backups are being called by an external agent?
Is there a way inside SQL Server to find out more about these backups?

Thank you.
Bill ParkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Matt BowlerDB team leadCommented:
Have look in these:

USE msdb
GO

SELECT TOP 100 * FROM dbo.backupfile
SELECT TOP 100 * FROM dbo.backupset
SELECT TOP 100 * FROM dbo.backupmediaset
0
lcohanDatabase AnalystCommented:
Most likely they are created via some maintenance plan and you can find that in SSMS:
Expand the server where you want to create/update your maintenance plan.
Expand the Management folder.
Expand the Maintenance Plans folder  and look for one that's likely doing a database backup by its name.
0
Bill ParkAuthor Commented:
There are no maintenance plans listed.
0
Bill ParkAuthor Commented:
What I think is happening - After digging deeper, it looks like Windows Server Backup is backing up the SQL databases each morning as part of a total machine backup:

Backup items: Bare metal recovery, System state, System Reserved, Local disk (C:)
File excluded: None
Advanced option: VSS Copy Backup
Backup time: Every day 3:00 AM

I don't know squat about VSS  but it looks like that at least SQL is being backed up. I'll have to figure out how to set up a tab so I can try restoring.

Thank you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.