We're have the same issue.

We have a problem in our environment. We use a .NET application that uses a 'buggy' stored procedure. The maximum number of connections to the database...

FYI,

I have set up operators and database mail to work. I just need to figure out how to set up the Alert in this case.

Would it be possible to...

I'm all set now. I made a typo with the physical name and it created wrong association. I had to restore the master in recovery mode and could go back...

Vidya,

I made the changes for temp database and things were fine.

I tried the msdb and model and my SQL system completely broke!!!

PLEASE HELP!

Ahh okay!

Thanks you very much.

Yes, the biggest culprit is indeed the temp database.

Since i am very low on disk space (13 MB), i will eventually want to move the other...

All,

I just made a new post. But any help from you guys would be appreciated:

I am fairly new to SQL Server 2005 Administration and don't feel comfortable running the script....

More information:

Directory of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

07/21/2008 01:37 PM .

07/21/2008 01:37 PM ...

BTW, I set it to Simple recovery mode yesterday. Did a Full backup yesterday.

Then, I turned it back to Full recovery mode before setting my maintenance plan in place...

no, this was a new deployment. We had accounted for plenty of disk space but there were no maintenance plans in place. I think we have more than sufficient space...

yes, it is Okay to restore it to the last full backup. This is not the most critical database.

thanks Gail.

Everyone,

I am all set.

I shrunk the size of the logs. I changed the recover mode to 'Simple' and ran a full backup.

I will put in proper maintenance plans into place.

thank...