sql 6.5 error message | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 6.5 error message

I get the following message when i try to connect to a sql 6.5 server. A connection could not be established to MyServer-[SQL Server ]Logical page 74255 of the log encountered while retrieving highest timestamp in database ‘MyDB’ is not the last page of the log and we are not currently recovering that database.
also the error logs of this morning shows the message below and now i don’t have a connection to the server.
Error : 933, Severity: 22, State: 1
Logical page 74255 of the log encountered while retrieving highest timestamp in database ‘MyDB’ is not the last page of the log and we are not currently recovering that database.
Run a DBCC CHECKDB to see if you have any corrupt pages. If the database is marked suspect you might be able to get it up and running by following this article: INF: Bypass (Emergency) Mode and DUMP TRANSACTION WITH NO_LOG
http://support.microsoft.com/default.aspx?scid=kb;EN-US;165918 Then you could try and take a backup of the database and restore it again. Make sure you are on the latest SQL 6.5 Service Pack:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;197177
http://support.microsoft.com/default.aspx?scid=kb;EN-US;274036
.. also check event viewer for any hardware related errors. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I can’t even connect to the server at the moment and i tried connecting with single user but with no luck…
So I need to connect first before i can do anything else

any ideas of how i can connect to sql server much appreciated…
Try to map to the drive on where SQL server error log resides mssqllog and read the log for information. And also check whether the SQL server services MSSQLSErver is started or not. BTW what was the error while trying to connect? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thanks. i managed to connect via query tool then dropped and recreated the dbase and everything looks to be ok now. cheers all…
]]>