|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > MSDE backup question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MSDE backup question
|
|
|
| Greetings all,
I'm quite new to SQL/MSDE
I've scheduled the attached batch file to run the attached backup script and
it all works well, the only problem is that if it fails nobody will ever
know.
What's the best practice for backups and error reporting with MSDE
databases?.
All thought are greatly appreciated.
Stig
begin 666 backup.zip
M4$L#!!0````(`&51(RT15.\4) ```"L````*````8F%C:W5P+F)A=/,/#O11
MT'55T,U42+:*24I,SBXMT"LNS%'0S4<2**DHX>4"`%!+`P04````" `$O"(M
M\?9'B4\```!8````"@```&)A8VMU<"YS<6QS<G3V#@U0<'$,<71R#'95B/;+
M+RK)*,_,2XE5"/%7</$,]E:P5?!3=[&*@<OH)25FJRN$>X9X*'CZ>88HZ"CX
M^0=[>P: &6[^0;Z.(0H`4$L!`A8+% ````@`95$C+1%4[Q0D````*P````H`
M`````````0`@`,"!`````&)A8VMU<"YB87102P$"%@L4````" `$O"(M\?9'
MB4\```!8````"@`````````!`" `@(%,````8F%C:W5P+G-Q;%!+!08`````
..`@`"`' ```##````````
`
end
| |
| Mark Allison 2002-10-05, 9:08 pm |
| Shedule your backup as a t-sql job in SQLAgent. On the advanced tab make
sure that Quit job then report failure is selected. On the notifications
tab, set up an operator to be notified on failure - this can be via email,
pager or Net Send.
--
Mark Allison
http://www.allisonmitchell.com
"Stig" <discostu53@REMOVE_THIShotmail.com> wrote in message
news:3d841788$0$16694$afc38c87
@news.optusnet.com.au...
> Greetings all,
>
> I'm quite new to SQL/MSDE
>
> I've scheduled the attached batch file to run the attached backup script
and
> it all works well, the only problem is that if it fails nobody will ever
> know.
>
> What's the best practice for backups and error reporting with MSDE
> databases?.
>
> All thought are greatly appreciated.
>
> Stig
>
>
>
| |
|
| Thanks alot Mark, I appreciate your input.
Stig
"Mark Allison" <mark@allisonmitchell.c0m> wrote in message
news:#$oe##IXCHA.2496@tkmsftngp09...
> Shedule your backup as a t-sql job in SQLAgent. On the advanced tab make
> sure that Quit job then report failure is selected. On the notifications
> tab, set up an operator to be notified on failure - this can be via email,
> pager or Net Send.
>
> --
> Mark Allison
> http://www.allisonmitchell.com
>
>
> "Stig" <discostu53@REMOVE_THIShotmail.com> wrote in message
> news:3d841788$0$16694$afc38c87
@news.optusnet.com.au...
> > Greetings all,
> >
> > I'm quite new to SQL/MSDE
> >
> > I've scheduled the attached batch file to run the attached backup script
> and
> > it all works well, the only problem is that if it fails nobody will ever
> > know.
> >
> > What's the best practice for backups and error reporting with MSDE
> > databases?.
> >
> > All thought are greatly appreciated.
> >
> > Stig
> >
> >
> >
>
>
|
|
|
|
|