Cannot start MSSQLSERVER
-
Hey guys, I have a problem starting my local SQL server, when I try to start it, then I get this error: Windows could not star the SQL Server (MSSQLSERVER) on local Computer.... I am using SQL server 2008. Thanks in advance.
Blikkies wrote:
Windows could not star the SQL Server (MSSQLSERVER) on local Computer....
Being telepathic I would say that your server installation does not like you. That is NOT a helpful error message. Try checking your event logs, you should get some more info from there.
Never underestimate the power of human stupidity RAH
-
Hey guys, I have a problem starting my local SQL server, when I try to start it, then I get this error: Windows could not star the SQL Server (MSSQLSERVER) on local Computer.... I am using SQL server 2008. Thanks in advance.
Has it ever worked? If this is a new install I would suggest uninstalling then reinstall.
-
Blikkies wrote:
Windows could not star the SQL Server (MSSQLSERVER) on local Computer....
Being telepathic I would say that your server installation does not like you. That is NOT a helpful error message. Try checking your event logs, you should get some more info from there.
Never underestimate the power of human stupidity RAH
Looked in the log and found this error: "2011-08-18 12:34:51.23 spid6s Starting up database 'master'. 2011-08-18 12:34:51.29 spid6s Error: 9003, Severity: 20, State: 1. 2011-08-18 12:34:51.29 spid6s The log scan number (352:448: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. 2011-08-18 12:34:51.29 spid6s 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." I tried rebuilding the master database but it failed to rebuild.
-
Has it ever worked? If this is a new install I would suggest uninstalling then reinstall.
It did work before, about a month back i started having this problem. Looked in the log and found this error: "2011-08-18 12:34:51.23 spid6s Starting up database 'master'. 2011-08-18 12:34:51.29 spid6s Error: 9003, Severity: 20, State: 1. 2011-08-18 12:34:51.29 spid6s The log scan number (352:448: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. 2011-08-18 12:34:51.29 spid6s 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." I tried rebuilding the master database but it failed to rebuild.
-
Hey guys, I have a problem starting my local SQL server, when I try to start it, then I get this error: Windows could not star the SQL Server (MSSQLSERVER) on local Computer.... I am using SQL server 2008. Thanks in advance.
-
Looked in the log and found this error: "2011-08-18 12:34:51.23 spid6s Starting up database 'master'. 2011-08-18 12:34:51.29 spid6s Error: 9003, Severity: 20, State: 1. 2011-08-18 12:34:51.29 spid6s The log scan number (352:448: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. 2011-08-18 12:34:51.29 spid6s 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." I tried rebuilding the master database but it failed to rebuild.
-
What error message are you getting when you try to rebuild the master?
The need to optimize rises from a bad design.My articles[^]