September 29, 2013 at 10:27 pm
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.
September 29, 2013 at 11:15 pm
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
September 30, 2013 at 2:37 am
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.
September 30, 2013 at 4:03 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply