Open up one of the jobs and go to the Notifications page.

Where it says E-mail does it say "When the job succeeds"?

(dup)

Can you show us what you've got so far?

Some free e-books here too if you haven't seen them yet. (Or you can pay for a proper copy.)

http://www.sqlservercentral.com/Books/

The recovery model is Simple. I thought with this option changes would be committed immediately and not save them to the log. BTW - full backups are done...

Googling got me this; worth a try?

http://thebackroomtech.com/2008/03/26/how-to-change-the-sql-sa-password-from-a-command-prompt/

Try Sqlservr.exe -m

or Sqlservr.exe -m -s INSTANCENAME if it's a named instance

(again)

Talk us through what you've done so far.

So: have you opened a command prompt window and navigated to the location of the BINN folder for your 2008 instance?

If you have,...

Sorry for the duplicate post.

Are you saying you want to pay somebody here $200-$250 a month to provide on-call support for you in your current job?

How did you end up in a job...

Are you saying you want to pay somebody here $200-$250 a month to provide on-call support for you in your current job?

How did you end up in a job...

Oh, to back you up!

Can you be a bit clearer about exactly what you want? It sounds as though you want somebody to send you one of their backup files, which can't be right.

By default it's located at C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn

but it depends on your installation. Have a look there first.