You can upgrade an instance of SQL Server 2005 Evaluation Edition to any other edition of SQL Server 2005 without uninstalling Evalation Edition.

Check-->http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

MJ

Adding to the list:

Operations Manager

SQLH2 and Performance Dashboard tools

Spiceworks for OS\hardware monitoring

RSS Reporter from xSQLSoftware

http://www.xsqlsoftware.com/Product/Sql_Server_Rss_Reporter.aspx

MJ

From BO:

If the database exists, RESTORE permissions default to members of the sysadmin and dbcreator fixed server roles and the owner (dbo) of the database.

Because fixed database role membership...

Try making use of database mail stored procedures under execute sql task once you enable database mail.

MJ

Have a look at http://www.sqlservercentral.com/articles/Administration/2605/

MJ

I think new database needs to be created with SQL_Latin1_General_CP1_CI_AS collation only..

MJ

Did you try lowering down -g switch memory? Is your problem still exists?

MJ

Give back the previous access and role membership one by one and see which one allow it to work..

MJ

No, you can't.

MJ

Have you tried SUSER_SID()

http://msdn.microsoft.com/en-us/library/ms179889(SQL.90).aspx

MJ

Are the backup files of same date when the job was invoked?

MJ

Search for the script on this site that will help you in implementing what tfoley said. If you don't get the script from here then let me know I will...

IF @rc = 1

BEGIN

PRINT "xp_startmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run...

Search for sp_delete_backuphistory stored procedure under books online and you will get your answer regarding backup tables pruning.

MJ

Is their any error message in error log?

MJ