Sql Server 2019 express edition backups problem

Question

I have created a C# application that uses a Sql Server database. I have Sql Server 2019 express edition installed. The problem I am experiencing is that Sql Server will randomly backup my database many times in a row (think once a minute for several minutes straight). I did not send it a command. I do not have windows 10 scheduler setup to run a job. Nada.

I've looked as hard as I can and cannot figure out what is causing this. I know that Sql Server 2019 Express editon CANNOT schedule backups as it does NOT have the agent by design. The log files don't help.

Any ideas greatly appreciated.

Answer 1

Hi @Darryl Hoar ,

Try to check if you have some third party backup tool backup the database, when you do not have a backup job.

The software used to perform the backup is recorded in the msdb.dbo.backupmediaset table. Try below T-SQL;

select software_name from msdb.dbo.backupmediaset  

For standard SQL backups, I get "Microsoft SQL Server".

> Thanks. I will give this a try. will it work on express edition ?

Yes.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 2

If you do not have the scheduled task to generate the backups, you need to make sure there is no any software to perform the backups. The following script will show the details of the backups. That may help you to figure out why.

SELECT * FROM msdb.dbo.backupset WHERE database_name = 'YOUR_DB_NAME';

Answer 3

It creates the .bak file for the database.