I get this procedure from a friend...

USE Master

GO

sp_configure 'show advanced options', 1

GO

reconfigure with override

GO

sp_configure 'Database Mail XPs', 1

GO

reconfigure

GO

sp_configure 'show advanced options', 0

GO

and after running this following error is occured..

Configuration...

Below are the all information about the installed server.

Microsoft SQL Server Management Studio9.00.1399.00

Microsoft Analysis Services Client Tools2005.090.1399.00

Microsoft Data Access Components (MDAC)2000.085.1117.00 built by: (_sqlbld)

Microsoft MSXML2.6 3.0 4.0 6.0

Microsoft Internet...

Thanks for you reply and i have already checked this artilce but there is no option in SAC and I tried the SQL server 2005 CD also. But nothing.....?

I checked but under the management there is no feature of Database mail. How I add this feature..???/

Yes i shrink the database mdf file and after shrinking the file the database mdf file size reduced to 65GB, and after taking the complete backup, the backup file size...