The error message is because some other user is already connected to the database. Try using ROLLBACK options, check for any open transaction or locks on that database. Even I...

Have you downloaded the correct version of SP3 installer?

Please confirm the SQL Server version by executing select @@version

Looks like the GUI has a restriction of 256 characters for the email field. However you can also add the operator using T-SQL and it works.

USE [msdb]

GO

EXEC msdb.dbo.sp_add_operator @name=N'OperatorName',

@enabled=1,...

As replied earlier by Ashish, your code does not overwrite the existing backups. Modify it to something like this

BACKUP DATABASE 'Datbasename'

TO DISK = 'EnterAStaticName'

WITH NOFORMAT,INIT, NAME = N''Datbasename'-Full Database Backup',

SKIP,...

This post has some answers

There is no 64 bit Oracle ODBC drivers. Please refer this

This helps you getting started.

Failing over the resources would confirm if the change has gone well with SQL Server or not

What is the job designed do? What is the error message with which the job fails?

Check if the database files are compressed. If yes remove the Compression option in the Operating System. Refer this

You may find this information useful.

Here is the one for SQL Server 2005.

SELECT d.name, MAX(b.backup_finish_date) AS last_backup_finish_date

FROM master.sys.databases d

LEFT OUTER JOIN msdb.dbo.backupset b ON d.name = b.database_name AND b.type = 'D'

WHERE d.database_id NOT IN (2,...

You may find this discussion useful

You should have got that option. Not sure though how it did not

You would have got a screen which looks like this. May be you have skipped that.