Re: Incremental Backups.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 08:49:15 +0100

Did you create the jobs using the maint plan in the first place? If so, I recommend you using the
GUI. If you don't want to use the GUI, I recommend scheduling the jobs yourself, as ordinary
Operating System Command jobsteps. If you look in Books Online, you will find sqlmaint.exe
documented. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nissan-NMUK" <nissan-nmuk@newsgroup.nospam> wrote in message
news:DE24B5AF-06EF-4247-BCD6-5CA918C78DF0@microsoft.com...
> Thanks for the answer but unfortunately I can't use the GUI - the maint plan
> is just used purely as a placeholder to list the database names.  The actual
> jobs had to be manually created as there are some complex dependencies and
> schedules surrounding then.
>
> Plus I rather quickly got annoyed by message boxes when adding additional
> schedules to the plan!
>
> Thanks.
>
> "Tibor Karaszi" wrote:
>
> > Use the maint GUI in the Database Maintenance plan folder instead of modifying the job directly.
> > Change from full database backup to transaction log backup. Note that transaction log backup is
not
> > exactly the same as incremental backup. Please read more in Books Online for details about the
> > backup types.
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/

Relevant Pages

  • Re: Bill Gates = Robin Hood?
    ... Jobs did not have much of a hand in the matter. ... well beyond the PARC ideas before Jobs got involved at all, ... If it weren't for the Apple engineers manoevering Jobs like that, ... The Mac GUI was created *despite* Jobs, and - well, all you have to do ...
    (uk.comp.sys.mac)
  • Re: Have fun with managing Data Protector schedules
    ... > schedule information) to automatically start backup jobs. ... The GUI would have to guess the rules from the current configuration. ...
    (comp.sys.hp.hpux)
  • Re: R. I. P. Steve Jobs
    ... The Mac wasn't the first computer with a GUI or a mouse, ... Jobs had a major focus on making the human interface as good as ... never a big fan of Mac computers ...
    (rec.music.gdead)
  • Re: Bill Gates = Robin Hood?
    ... Jobs did not have much of a hand in the matter. ... If it weren't for the Apple engineers manoevering Jobs like that, ... The Mac GUI was created *despite* Jobs, and - well, all you have to do ... On the drive back to Cupertino, it is reported that Jobs told Atkinson to ...
    (uk.comp.sys.mac)
  • Re: Ongoing Maintenance problems
    ... I suggest you define a report file for the maint plan and post that report file (or relevant part ... > Backup Job, and got a SQLSTATE 42000 error 22029 on each step. ... > would have thought that there wouldnt be any problems in running the jobs. ...
    (microsoft.public.sqlserver.programming)