Verify all DBs are part of a Maintenance Plan

By StormNorm, 2004/10/01

Total article views: 222 | Views in the last 30 days: 9

Rate this |

Join the discussion |

Briefcase

This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a Plan. Very useful for auditing your servers periodically to make sure you are not missing any databases. Verified to work for both SQL 7 and SQL 2000.

Notes: If you use the All system databases or All user databases options in your Maintenance Plans, individual dbs will not be listed as linked to those plans.

By StormNorm, 2004/10/01

Total article views: 222 | Views in the last 30 days: 9

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Stored Procedure to read tape backup log

By Neil Jacobson | Category: Miscellaneous

| 213 reads

Recompile Views/SPs from DOS from .SQL Files.

By Mindy Curnutt | Category: Miscellaneous

| 464 reads

Re-create Transaction log file

By philcart | Category: Miscellaneous

| 635 reads

sp_GetLastBackup

By TJay Belt | Category: Miscellaneous

| 307 reads

Like this? Try these...

An interview with Robin Dewson

By Jon Winer | Category: Miscellaneous

| 3,128 reads

Beta Developers Wanted

By Press Release | Category: SQLServerCentral.com

(not yet rated) | 2,711 reads

UDF to get Day of the Year

By schawdhury | Category: Miscellaneous

| 165 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com