Skip to Content
Former Member
Jul 26, 2010 at 01:41 PM

Dispatcher not starting, inconsistencies with database.


Hi guys,

In my coy a member of staff shutdown the SAP Server abnormally causing inconsistencies in the database. The SAP system runs on an MSSQL database.

The next morning the dispatcher was not starting and i checked the database. Apparently, i could not login to the database so i changed the default database to master. I could login alright so i tried running the ALTER LOGIN.... which did not run.

Drilling down i found out that the database was marked "SUSPECT" so i tried to take it offline and detach it. I got the error "attempt to retrieve data for object failed for server".

I would appreciate your prompt response on this.