Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL SERVER 2005 STARTING PROBLEM Expand / Collapse
Author
Message
Posted Sunday, September 29, 2013 10:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 14, 2014 7:24 PM
Points: 25, Visits: 40
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.
Post #1499829
Posted Sunday, September 29, 2013 11:15 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:53 AM
Points: 1,904, Visits: 2,825
Well, did you
consult the event log or other applicable error logs for details"
?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1499833
Posted Monday, September 30, 2013 2:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 14, 2014 7:24 PM
Points: 25, Visits: 40
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.
Post #1499896
Posted Monday, September 30, 2013 4:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 42,451, Visits: 35,506
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 2008, MVP
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

Post #1499913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse