Re: Automating 'results to file' in script

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 08/07/04 

Date: Sat, 7 Aug 2004 18:48:51 -0400

> However, if you want to backup all databases, you might want to have a
> look at maintenance plans in SQL Server. They have an option to backup all
> databases, or either all user databases or all system databases.

Not correcting but just clarifying, maintenance plans will allow you to set
up backup and other tasks for individual databases or small groups of
databases, not just the three sets you mentioned (all, all user, all
system). 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)

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: Proper SQL database backup procedures
    ... maintenance plans for backing up the databases and transations logs. ... What should be backed up first, the databases or the transaction logs? ... -Full backup or Differential backup ...
    (microsoft.public.sqlserver.server)
  • Re: Proper SQL database backup procedures
    ... maintenance plans for backing up the databases and transations logs. ... What should be backed up first, the databases or the transaction logs? ... -Full backup or Differential backup ...
    (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)