May 28, 2002 at 6:50 pm
Setting: Sql 7 server (no SP due to conflict with PowerBuilder), Windows NT (SP6)
The server was working fine until about noon today. Then I received notification that our hourly trans log dump routine failed. I ran the trans dump manually but it still failed. The error message is
"Microsoft SQLMaint Utility (Unicode) Version [Microsoft SQL-DMO (ODBC SQLState: HYT00)]
Error 0: [Microsoft][ODBC SQL Server] Timeout expired.
Another odd thing:
1. I can connect to the server without any problem using EM on my local box. But when
I try to connect using EM on the server itself, it times out (similar ODBC error message to above). It also hangs when I try to login locally to the server using Query Analyzer. Oh, yes, I can login in remotely to the server using QA.
2. I just rebooted the server. Now I can’t get in even remotely using EM or QA!
3. While I still can’t use EM or QA on the server I did use net stop MSSQLSERVER and SQLSERVERAGENT to stop the services. Then I restarted them using "net start". That worked fine but EM and QA still won't let me in locally or remotely.
Any help much appreciated!
Bill
May 28, 2002 at 6:59 pm
Might check to see if sqlmaint.exe is still running, might have gotten hung up.
Andy
May 28, 2002 at 9:44 pm
Increase your timeout as well. If the network or server are busy, the defaults don't cut it.
Steve Jones
May 29, 2002 at 1:35 pm
More info on this problem: this morning everything was working fine (surprise!) on the server. That is until 11am when the timeouts started up again during a DB dump. Here's the error message:
Microsoft (R) SQLMaint Utility (Unicode), Version
[Microsoft SQL-DMO (ODBC SQLState: HYT00)] Error 0: [Microsoft][ODBC SQL Server Driver]Timeout expired
I recreated a new SQLMaint job but it had the same problem. Next I dumped the databases manually from QA (backup database...) and it worked fine. Maybe this is a SQL Main problem?
TIA,
Bill
May 29, 2002 at 2:07 pm
I've seen timeouts when there was heavy fragmentation - run your dbcc's recently?
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply