SQL SERVER 2005 STARTING PROBLEM

  • Hai Every One.

    I am using SQL Server-2005.

    When i am trying to start my SQL Server(MSSQLSERVER) it was not starting and giving following error.

    "the request failed or the service did not respond in a timely fashion.

    consult the event log or other applicable error logs for details"

    Can Anybody help me Please.

  • Well, did you

    consult the event log or other applicable error logs for details"

    ?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Thanks for your reply.

    When i check my error log.it was like this

    1--The log scan number (673:392:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

    2---Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

    Can Anybody help me please.

  • Master is damaged. You'll need to rebuild the system databases, then once SQL starts restore your backups of the system databases to get all your logins and other stuff back.

    http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply