07-01-2014 01:45 AM
Ive managed to sucessfully run the maintenance tasks via the menu but when I schedule it to run I get the following error:-
Failed to log into the database. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
Ive looked at everything I can and I cant find a problem with access rights or database availability as the backup runs successfully only a few hours earlier..
Any advice much appreciated.
07-10-2014 09:50 AM
Let's try increasing the database timeouts:
Double the given values for DatabaseCommandTimeOut.Default, DatabaseConnectionTimeOut.Default, and DatabaseCommandTimeOut.Long.
Restart SQL server. You can do this from ACTDIAG.EXE through the tools menu. Let us know if the maintenance runs this time.