How to create maintenance plan without Northwind and Pubs

From: Markku Vainio (google_at_netti.fi)
Date: 03/02/04 

Date: 2 Mar 2004 01:25:24 -0800

When creating a new database maintenance plan, there are four
different sets of databases to select:
  o All databases
  o All system databases (master, model, and msdb)
  o All user databases (all databases other than master, model, and
msdb)
  o These databases ...

I think that the most useful choice would be "All user databases
(excluding Northwind and Pubs)". But there are no such choice. Why?
How can I exclude the two demo databases from "user databases"? I know
I can delete them or mark them offline, but do I have to? I still want
to use them sometimes and therefor keep online.

So far I have used the "These databases" choice but it's sometimes
hard to keep track of all new and deleted (and offlined) databases.
The "All user databases (excluding Northwind and Pubs)" would be a
perfect solutions.

If I backup all user databases INCLUDING Northwind and Pubs, how can I
make some kind of trigger to detect a new backup file on disk and
delete it? The deletion should occur before the file would be written
to tape.

Markku

Relevant Pages

  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Rebuilt master, whats next?
    ... one thing remains unclear to me: what will happen when I restore ... master then start the server and user databases aren't where they ... Will the references to them in master be automatically ...
    (microsoft.public.sqlserver.server)
  • RE: Moving master and msdb to a new disk
    ... databases (master, msdb) to a new disk. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)
  • Moving master and msdb to a new disk
    ... databases (master, msdb) to a new disk. ...
    (microsoft.public.sqlserver.clustering)
Loading