Hi friends, I have checked the log of the sql server and also the backup history and I notice that backups are being made to disk at a certain time but I see no maintenance plan or some JOB that does this, where else can the process be searched ? Thanks.
Search the operating system where SQL Server is implemented, since someone could have used Windows Task Scheduler to program this through a T-SQL script executed through SQLCMD. This person must have privileges of both Local Admin in the operating system and SYSADMIN in SQL Server to perform this activity.
In the Microsoft support base, indicate how this can be done, without needing a Job or Maintenance Plan in SQL Server: link
There are several ways to make a backup without it being a maintenance plan, as indicated by @Guillermo, This consulata allows you to see where they are saved and which user was used to make the backup Author of the script
-- Get Backup History for required database
SELECT TOP 100
s.database_name,
s.description,
m.physical_device_name,
CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,
CAST(DATEDIFF(second, s.backup_start_date,
s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' TimeTaken,
s.backup_start_date,
CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn,
CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn,
CASE s.[type]
WHEN 'D' THEN 'Full'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Transaction Log'
END AS BackupType,
s.server_name,
s.recovery_model,
s.user_name
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id
WHERE s.database_name = DB_NAME() -- Eliminar es ta linea para ver todas las BD
ORDER BY backup_start_date DESC, backup_finish_date