New Question

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Monitor SQL maintenace plan

Votes:

0

Your Vote:

Up

Down

Guys,

I'd like to monitor my MSSQL backups if they running successfully or not. Am using SQL 2008 R2.

Is this possible with PRTG?

Cheers

Tony

backup maintenance sql

Created on Jan 28, 2016 12:09:01 PM by Antony (10) ●2



3 Replies

Votes:

0

Your Vote:

Up

Down

Hi Antony,

Did you already see this KB article?
https://kb.paessler.com/en/topic/19533-does-prtg-can-support-database-backup-jobs-monitoring

Created on Jan 28, 2016 2:26:42 PM by PRTG Tools Family [prtgtoolsfamily.com] (13,413) ●3 ●4



Votes:

0

Your Vote:

Up

Down

Hi,

Where do I create the stored procedure when I want to monitor all the database backups? I am using SQL management studio.

EDIT: I have this working now. Except that the sensor cannot handle that the value might be NULL, such as for the tempdb and offline DB's.

Created on Jan 28, 2016 2:53:04 PM by Antony (10) ●2

Last change on Jan 28, 2016 7:22:18 PM by Luciano Lingnau [Paessler]



Votes:

0

Your Vote:

Up

Down

That would basically be possible in any existing database you like.

Created on Jan 28, 2016 4:21:07 PM by PRTG Tools Family [prtgtoolsfamily.com] (13,413) ●3 ●4



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.