Re: Viewing properties of scheduled backup job

From: PD (anonymous_at_discussions.microsoft.com)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 17:39:35 -0800

The new maintenance jobs i've scheduled are listed under
there, but none of the existing jobs are.

If i right click a database, schedule a backup, it does
not appear under here. It only seems to include jobs
created under the maintenence wizard in here.

>-----Original Message-----
>There is a node in EM under the Maintenance folder that
list the scheduled
>jobs. You will find it there.
>
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"PD" <anonymous@discussions.microsoft.com> wrote in
message
>news:A2430F20-0A93-492B-ABA4-
FB9BCAD281DA@microsoft.com...
>> Our previous DB admin has configured nightly full
backups of our database
>individually using right click-->all tasks-->Backup
database and then
>setting schedule options.
>>
>> It works and the databases are backed up each night,
overwriting the
>previous one. He's since gone and i've set up a new
maintainance schedule
>instead using the maintainance wizard to back up all the
databases nightly
>and two weekly and also to perform optimisations and
integrity checks as
>well. Thing is, i cant see how to remove his existing
nightly backups - they
>dont show up anywhere, all the stuff im setting up now
is visible under
>'maintenance plans', but his jobs dont appear anywhere
within Enterprise
>manager - where do jobs go when they are set up as he
did.
>>
>> I tried it myself, right click a DB, schedule a
backup, and then try to
>find any record this job exists - there isnt one that i
can see anywhere. It
>runs ok though.
>
>
>.
>

Relevant Pages

  • Re: backing up sql server DB nightly
    ... There are 2 options to schedule a backup of database. ... Maintenance plans use SQL agent to schedule so ensure that SQL Agent service ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie Maintence Plan Question
    ... placing the backup files? ... You should take out the option to remove the unused space. ... database and usually makes it grow as well. ... > But I'm worried that maintaining separate jobs for each database to handle ...
    (microsoft.public.sqlserver.setup)
  • Re: database backup schedule not working
    ... On the schedules tab hit "New Schedule" ... You will want to backup your user databases, master, and model. ... > I'm running SQL server 2000 on a Windows Server 2003. ... > Database, selected the local disk as a backup destination, clicked on ...
    (microsoft.public.sqlserver.tools)
  • Re: Viewing properties of scheduled backup job
    ... I think your looking under the Maintenance Plans node. ... under the scheduled jobs node. ... > If i right click a database, schedule a backup, it does ... >>setting schedule options. ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup: How to schedule two different backup jobs
    ... I want to schedule two different backup jobs, ...
    (microsoft.public.windows.server.sbs)