Re: Back up plan

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 08:06:58 -0400

You can everything but the differential in the Maintenance Plan Wizard..

You can also go to the Backup Dialog box in EM and select the options you
wish and choose Schedule, this will create jobs for you ( but these jobs are
for a single database each.)

Go to SQL EM select a server , Go to the Tools menu at the top, and choose
Backup database.... select all of your options for FUll backup, and choose
schedule. then do the same for log, and again for differential...

I like using the Maint Plan Wizard because it gives me unique file names,
but you can write a little code for that. and it also removes old backups,
but you can also write script for that... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <NOSPAMalan_pltse@yahoo.com.au> wrote in message
news:Ofv6BQyjEHA.1136@tk2msftngp13.phx.gbl...
> Anyone can tell me steps to do a backup plan in E.M ?
>
> What I want to do :
> 1) Full backup on Sunday 8 pm
> 2) Differential backup at 8 pm Monday to Saturday
> 3) Transaction Log every 2 hours
>
> It seems cannot be done the whole things in Maintenance Plan in E.M.
>
>
Quantcast