Sometimes it might be due to long running queries which lock the resources and these are released only on commit. If its sql 2000, see if you can set the...

At the same time run some compares on couple of frequently used table for missing indexes. That does happen sometimes.

Since the database is set to autoshrink, the most the autoshrink will do is about 25% . You need to run dbcc shrinkfile couple of times. If it does not...

You can try to run execution plan to see what it does, though u say sometimes it timesout. Try to get TSQL event in profiler and SP events. That should...

This is how SQL works and is better off then Oracle :))

The reason you might be getting the filegroup is full even though it set to autogrow is: whenever the filegroup has reached its max at that given point of time...

There are different kinds of softwares which you need to buy licences to install. One is call Advanced password recovery tool. Try to search for downloads on google search.

Good Luck.

...

You can set the number of days/hours you want the reports to be kept and rest are deleted on a periodic basis. Did you mean backup history from MSDB database?

Note:...

Like you said that the mmaint plan requires to be in single user mode. During the 50-60 min time do the users require to connect to the database. If yes...

Regardless of the recovery model, as said in the comment before any activity done is logged. There are couple of ways you could that will decrease the number of enteries...

Silly but still good to look at it and need some info:

1.Was the job suceesfully executed prior to this error.

2. Were there any changes done to the job before it...

It might be the refresh process got hung or there was some other process that was blocking DTS job. It does happen sometimes the client side doesn't get refreshed for...

Below are some of the places to look for though you might have done these already:

1. Check to see on what filegroup is the TABLE and see if that filegroup...

After reading all the comments wanted to include my 2 cents. If its a SQL2000 box, maybe you can use having a view on the table and in turn index...