Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Successfull Back up

Author  Topic 

jsinks
Starting Member

13 Posts

Posted - 2007-03-02 : 03:13:01
Can anyone help me!!! Is it possible to write a scrpt to alert me through e-mail that the database back-up has run successfully...

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2007-03-02 : 07:46:02
If you use the Database maintenance planner it will perform those steps for you. Otherwise you can add to your script
xp_sendmail. This requires that you have sql set up to use SQL Mail.

Raymond Laubert
MCDBA, MCITP:Administration, MCT
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-02 : 07:55:52
Duplicate post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79929


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

divided
Starting Member

12 Posts

Posted - 2007-03-22 : 15:18:03
setip an alert to notify you when the backup jobs completes.
Go to Top of Page
   

- Advertisement -