where is SQL Server Database backup scheduled from

Hello, this may be a basic question but I can't seem to find the answer.

We are running Windows Server 2008 R2, and SQL server 2008 R2. In the SQL Server logs in the SQL Management Studio, the attached log entries are created. It is doing database backups at 1AM every morning. I cannot seem to find where the configuration\setup is that is starting those backups.

There are no scheduled SQL jobs at that time, we are however doing Windows Backups at 1am. The Windows Backups are full/incremental backups of the disks, full metal, system state etc.

Could it be the Windows backup that is doing the database backups? or if not, does anyone know where I would look to modify/stop/etc the SQL database backup that is being shown in the log file? (database names removed from the attachments)

Thanks
log1.jpg
log2.jpg
LVL 2
ChiITAsked:
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.

ShareD_PointCommented:
Hi,

The backup is Scheduled in SQL Server.

Follow the below step to find the Scheduled backup Plans.


Open Microsoft SQL Server Management Studio.

Go To YourSQLServer-> Management -> Maintenance Plans.

You can find the scheduled Backup Jobs.

Hope this may helps.
0
ChiITAuthor Commented:
Hello, thank you, I just checked and there are no maintenance plans there. its completely blank...
0
ShareD_PointCommented:
Did you select the appropriate SQL server instance?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

ChiITAuthor Commented:
correct, there is only one instance running...
0
ShareD_PointCommented:
SQL server might have backed up by some third party backup solutions. Check your server Event logs and see any SQL server backup solutions entry exists. If yes, you may need to concentrate on that product.
0
ChiITAuthor Commented:
In the Windows Event log, it shows the same entry as in the attached screen shots...there is no 3rd party software.
0
ChiITAuthor Commented:
Does Windows Server Backup do SQL Database backups?
0
ShareD_PointCommented:
Windows Server Backup will not do SQL Database backups

Which edition of SQL server 2008 R2 are you using?
0
ChiITAuthor Commented:
2008 R2 Standard Edition, 64 Bit
0
ShareD_PointCommented:
SQL Server Agent may be used to schedule backup jobs. Run the below query in msdb database.

EXEC MSDB.DBO.sp_HELP_JOB

The result will provide information on jobs that are Scheduled to run using SQL Server Agent.

Hope this may helps.
0
ChiITAuthor Commented:
I will do this today and let you know. Thank you
0
ChiITAuthor Commented:
I found where it was, it turns out it is calling a program from a scheduled Windows task..thank you for your help though!
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
ChiITAuthor Commented:
Found this by changing the backup times to see what affected the log file timestamp..
0
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.