Thanks Everyone for the information.

Can you please let me know what best can i do to increase the performance?

Thanks a lot Gianluca .

The job was created by ETL team here and we are now in a process of fine tuning that.

I am not sure whether they will accept...

No sir :-D,

I mean update the other existing statistics,rebuilding or reorganising indexes

Thanks for the reply,

Its restricted growth only but 2097152MB

Thanks a ton Glen & Jason..

Thanks Suresh,

Hope u meant that differential backup and full backup can be appended to the same file.

Adding to above

Is it possible to append differential backup to a full backup?

Can you please let me know the default database of the user you used to connect?

Is your CPU 100% saturated??

Thanks Toby

Thanks for the Reply Toby

Just try close the SSMS and reconnect to server

Thanks Adi,

I ran (grant exec on dbo.sp_send_dbmail to user_name) and now its accesible.

SQL Server 2008 providing table backup or script out table and then use import export?

Think you cant rename a server

If its a small db then backup and restore it