<div>
Have look in these:<br />
<br />
USE msdb<br />
GO<br />
<br />
SELECT TOP 100 * FROM dbo.backupfile<br />
SELECT TOP 100 * FROM dbo.backupset<br />
SELECT TOP 100 * FROM dbo.backupmediaset
</div>


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

Bill Park

<div>
Most likely they are created via some maintenance plan and you can find that in SSMS:<br />
Expand the server where you want to create/update your maintenance plan.<br />
Expand the Management folder.<br />
Expand the Maintenance Plans folder &nbsp;and look for one that's likely doing a database backup by its name.
</div>


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.

<div>
There are no maintenance plans listed.
</div>


<div>
<div class="content wysiwyg-content">
We have SQL Server 2016.<br />
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.<br />
<br />
The System Agent only shows two jobs, neither associated with backups.<br />
<br />
Does this indicate that the backups are being called by an external agent?<br />
Is there a way inside SQL Server to find out more about these backups?<br />
<br />
Thank you.
</div>
</div>


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.

How are SQL Server backups being run?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.