what is the source of these backup files

Rishabh Patil 121 Reputation points

Hi All,

I am dealing with a strange issue where in one of the instance, in one folder some job/something else is generating db backup files. I have checked all the sql agent jobs but none points to that folder location.

These backup files are occupying space in terabytes and we were not able to find the culprit yet.

I have checked other servers which might have pointed to the path N'H:\Backup\' but they are not doing anything in there.

Is there a better way to find the source of those backup files?

Any help would be appreciated.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,722 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 28,701 Reputation points

    Though we dont find that job when logged in as sa user

    As SysAdmin "sa" you can see everything in SQL Server, no need to logon with a different account.

    That the service account as user issues the backup do not necessarily mean, it's done by a SQL Server-Agent job, it can also be done with Windows Scheduler, where the service account is assigned to the schedule.
    See Schedule and automate backups of SQL Server databases in SQL Server Express

4 additional answers

Sort by: Most helpful
  1. Olaf Helper 28,701 Reputation points

    generating db backup files

    A .BAK file can be anything, just a file extension, so first validate if it's really a DB backup file using RESTORE Statements - HEADERONLY (Transact-SQL) or use SSMS.

  2. Tom Phillips 17,631 Reputation points

    You would not see the directory in the SQL Agent job if it was in a maintenance plan.

    0 comments No comments

  3. Rishabh Patil 121 Reputation points

    I have setup a trace between 6 am to 7 am to catch the Audit backup/restore event. Hope I find it in login name! I will update. thanks

  4. Rishabh Patil 121 Reputation points

    Hi All,

    Thanks for all the helpful replies.

    We found that backup was requesting from one data warehouse etl, as the etl triggered at the same time that backup file created.

    We have asked ETL guys to remove that code from there, and also we have deleted all the files from the folder.

    0 comments No comments