Schedule MSDE Backup - HELP!!

Can anyone give me instructions on how to SCHEDULE backups for MSDE2000?
Enterprise manager will do backups manually but the scheduled ones don't
keep the file location of the backup. If you enter a maintenance plan and
then go back to it in properties, the path for the backup is gone and you
can't re-enter it. My developer had issues when he tried to code a backup
instead of using Enterprise Mgr. Right now I manually back them up but I'd
like to schedule something once a day and then put that whole backup
directory on tape at night. I've seen some posts from other on the web who
have the same issue but have been unable to find anyone who found a fix.
Best Wishes,
Steve
hi,
"bozo" <bozo@.bozosplace.com> ha scritto nel messaggio
news:10nc3d57n55lc0d@.corp.supernews.com
> Can anyone give me instructions on how to SCHEDULE backups for
> MSDE2000? Enterprise manager will do backups manually but the
> scheduled ones don't keep the file location of the backup. If you
> enter a maintenance plan and then go back to it in properties, the
> path for the backup is gone and you can't re-enter it. My developer
> had issues when he tried to code a backup instead of using Enterprise
> Mgr. Right now I manually back them up but I'd like to schedule
> something once a day and then put that whole backup directory on tape
> at night. I've seen some posts from other on the web who have the
> same issue but have been unable to find anyone who found a fix.
I do not use maintenance plans, but usually use jobs to do it..
you have to code using sp_add_job msdb system stored procedure, and adding
job steps and job schedules...
the master job step will then be a Transact-SQL subsystem step, where you
store the actual BACKUP DATABASE... statement(s)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Bozo,
There's a tool on our site (MSDE Manager) that will let you do this. It's
free for personal use.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"bozo" <bozo@.bozosplace.com> wrote in message
news:10nc3d57n55lc0d@.corp.supernews.com...
> Can anyone give me instructions on how to SCHEDULE backups for MSDE2000?
> Enterprise manager will do backups manually but the scheduled ones don't
> keep the file location of the backup. If you enter a maintenance plan and
> then go back to it in properties, the path for the backup is gone and you
> can't re-enter it. My developer had issues when he tried to code a backup
> instead of using Enterprise Mgr. Right now I manually back them up but
> I'd
> like to schedule something once a day and then put that whole backup
> directory on tape at night. I've seen some posts from other on the web
> who
> have the same issue but have been unable to find anyone who found a fix.
> --
> Best Wishes,
> Steve
>