Re: How to create maintenance plan without Northwind and Pubs

From: Bart Simpson (bartsimpson000_at_yahoo.com)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 10:40:34 -0800

Answering on your last paragraph.
You can add one more CmdExec step to the backup job:

if exist c:\backup\pubs*.bak del c:\backup\pubs*.bak
if exist c:\backup\Northwind*.bak del c:\backup\Northwind*.bak

Bart Simpson

On 2 Mar 2004 01:25:24 -0800, google@netti.fi (Markku Vainio) wrote:

>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: Database Maintenance Plan Problems
    ... the system databases such ... Deleted by Maintenance Plan ... >>A maintenance plan job to backup transaction logs ... >>Backup can not be performed on this database. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Maintenance Plan Problems
    ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
    (microsoft.public.sqlserver.server)
  • Re: database log truncated, transaction log backup job failed
    ... I got it fixed by selecting the specific databases in the Maintenance plan. ... step that runs the transaction log dump". ... Unfortunately, I recall now, that maintenance plans do a good job of ... it seems like the only time you need to backup the transaction logs is ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup SBS 2003
    ... >> backup your system successfully. ... We shouldn't backup the Exchange log files since we are backing ... With the databases, you can decide to move the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)