After doing some more testing with different backup strategies, I have discovered a rather large problem which may explain my confusion.

We have TSM backup which backs up every...

When you right clicked on the server there was no list of tasks. I got Infrastructure to put the server back onto the network which then enabled me to...

I'm doing log backups once a day; its a very small database where the information rarely changes. However it is the only system which does have a true test...

I've got a database and log backup that took place before the deletion and will have a log backup after the deletion. This will run in the early hours...

I've just run a full database backup and transaction log backup. I've asked my data admin colleague to delete something from his database via the application this afternoon. ...

You said

Are you specifying STOP AT, or just restoring all the logs?

What are the exact command you're using? If you're using the Management Studio wizards, I would suggest you...

GilaMonster (6/30/2009)

Personally, my preference is that each backup goes to a separate file that contains the date and time as part of the name. That way I don't have to...

After doing more tests, I'm still getting confused. I'm doing a full database and a transaction log backup every night. In EM, I can see a database and...

It is, it is! How marvellous is that! A server telling me when its not happy.

Happy days. Thanks for the help

Jeffrey Williams (6/12/2009)

---

You need to configure SQL Server Agent's alert system to use database mail.

Right-click on SQL Server Agent in Object Explorer and select properties. Select the Alert page...

Yes. I'm beginning to get a grip of this now. I'll do some tests and verify my processes.

Thanks for your help (but I may be back!!)

Thanks. I've configured them. Lets hope I never see them!

Thanks for that. Actually to please them, I've kept our backups running and set up a dump for them! Its only a minor database and I don't think...

I'm beginning to get somewhere now. The log file shows the following error message

The mail could not be sent to the recipients because of the mail server failure. (Sending...

Being somewhat older (!) I've found that I may get rusty in one technology but I get better at newer ones. I started back in the days of paper...