Thanks alot for ur valuable solutions.

Can you plz post the script to check that sql agent is running or not in all servers. im also tring for that. My mail id :sanya.bandaru@gmail.com

Hi gail, thank you for responding. We are having up to date backups. we are restoring from them by deleting sespect mode database nad creating new database with same name...

Scheduled T-log and differential bakup jobs which runs daily.The space allocated to the MDF and LDF are completely filled and there is no space in the hard disk.......

Hi Manoj,

Im new to this filed. can u please explain how Check the fragmented tables and rebild the index on that particulter Tables.

daily scheduled jobs whick takes T-log and differential backups. There is no free space left in the hard disk. is there any remedy to run the jobs with out failing.

Thank you for your response.

Daily we used to take T-log back up which is scheduled and there is no free disk space available in the hard disk.can i do...