Database Backup in a Maintenance Plan

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 18 Mar 2008 22:43 GMT

I want to write a SQL query to find if a perticular database is backed up in
any Maintenance plan or not.

Is there any way to write this query.
I can surely open all the Plans and view it, but I need to find it out using
a query.

Please let me know if it is possible.

Thanks in advance, Steven

Reply to this Message

Andrew J. Kelly - 19 Mar 2008 00:43 GMT

Which version are you talking about? If it is 2000 then have a look at the
sysdbmaintplan_databases table in msdb.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

>I want to write a SQL query to find if a perticular database is backed up
>in any Maintenance plan or not.
[quoted text clipped - 6 lines]
>
> Thanks in advance, Steven

Reply to this Message

Tibor Karaszi - 19 Mar 2008 08:45 GMT

... or perhaps the backup history tables in msdb?

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Which version are you talking about? If it is 2000 then have a look at the
> sysdbmaintplan_databases table in msdb.
[quoted text clipped - 8 lines]
>>
>> Thanks in advance, Steven

Reply to this Message

Steven - 19 Mar 2008 22:48 GMT

Thanks for the suggestion.
I'll take it from her.

Thanks again, Steven

> ... or perhaps the backup history tables in msdb?
>
[quoted text clipped - 11 lines]
>>>
>>> Thanks in advance, Steven

Reply to this Message