I have seen simialar problems with sqlmaint and it is due to something happening to the .dll in memory, thats why restart of agent is re-setting it.

Possible options:

server reboot

copy...

thanks for the reply.

yes, xp_delete_file works.

I have found the solution. In the clean up task I specified the file extension as .bak, should have been just bak without the leading...

reading your first entry again, set your max server memory in SQL. Leave enough for any other processes on the server. The OS should have at least 2GB.

see http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

there was an article on the web called 'Making the Most Out of the SQL Server 2005 Performance Dashboard' but their server appears down at the moment ot article...

you could truncate the log and shrink it on the live side then when it restored on your reporting server the log will be sgrunk over there as well.

IMPORTANT -...

In perfmon check out SQL server:Memory Manager Total and target server memory, this will show you memory being used by SQL (values should be the same). If you have not...

use sp_help_revlogin procedure - see article http://support.microsoft.com/kb/246133

providing all the files are in the same filegroup SQL uses a proportional fill system where it tries to keep all the files filled to the same percentage. To do...

here's mine....

I run it from sqlagent outputting to a file. that way I have a history if the block is gone by the time I get there. It gives enough...

y0u will see an i/o spike on the drive containg the logs and the drive you are backing up to when the backups take place, this is unavoidable.

your idea of...

cannot resist adding my two pennys worth in such exalted company. As Will Summers alludes to in his post, if with your chosen clustered index new values could not be added...

checks who owns the stored procedure, you may need to prefix the sp name with the owner, espec if you are not dbo.

if thats the case you would be better off using nightly backup\restores. This will be simpler to maintain and not be affected by any application upgrades.

horses for courses.

not got an hour and a half for that presentation at the moment, is there a performance improvement spreading the tempdb data files across multiple files on the same drive?

the naming convention you give suggests this is a named instance. It is not possible to remove the servername part from the named instance name. If the naming convention is...