What is error no.?

You can use following:

EXEC msdb.dbo.sp_set_sqlagent_properties @databasemail_profile=N''

HTH

Good one, thanks.

Are you doing with GUI or commandline i.e. T-sql?

You can find lots on google. Select as per your need.

Good One, thanks.

pl. provide more details what exactly are you doing? And how you are setting up backup?

Usually there should not be any issue you can store backup locally as well as...

This talk is very intersting and many threads are very valid here is my stand:

In cloud, DBA do not know how their data is taken care? who do have access...

Yes, message you have posted is clearly mention that backup is successful. Resend the correct message so people can help.

Looks like your system is not production. If it's not prod you can change the recover to simple and shrink the logfile. If you would like to keep the full...

Replace * with count(*) in your query

Refer the execution plan for further understanding.

However general flow of query is like this...

Query > Algebrizer > Optimizer > Execution > output

Just to head start refer following thread...

http://www.sqlservercentral.com/Forums/Topic449875-360-1.aspx

Good one, thanks.

Evaluate the possibilities of "Snapshot Isolation" in your environment.