Thanks Mark it really helped me a lot .

Your help is required for me in future as well.

Thankyou very much

Pavan Posani 

yes i want to truncate all the tables in the database can you please tell me the syntax for that

pavan

Hi Deepak

Iam able to ping my smtp server does this means that port 25 is open or do i need to ask our networking guys to open that

quick reply really...

Hi Deepak

Thanks a lot

bye

pavan posani

Hi deepak

I resolved the problem actually that is a very simple mistake that i have done,in the t log back up task in the maintennace plan has not been enabled...

Hi Deepak

This is the message which iam getting when the job is failed in the job history

Date  6/11/2007 6:57:39 AM

Log  Job History (User Data Bases (larger) Greater than 25 gb.T log back...

Hi John

Iam sure that I have enough  space on the disk to which iam doing the t log back up.

thankyou

pavan posani 

Hi deepak

I have checked all my dbs and they are in full recovery mode and i didnt understand why they are failing.

please help me out of this

thankyou

pavan posani

Thanks a lot to every body iam able to configure it and send mails

looking for all your support for my future challenges in  sql server

thankyou

pavan posani