Solved

machine crashed and now sql server wont connect

Posted on 2014-01-16
9
567 Views
Last Modified: 2014-01-22
hi
there was a power cut and now sql server wont connect (see attached)
i've tried using windows authentication too but i get the same issue

please can any one suggest what to do to fix it please
its sql server 2012
0
Comment
Question by:websss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39787643
Hi,

I don't see the attachment.

Is SQL started? Have you checked with the configuration manager?

Are all the drives connected?

Have you rebooted the server after the power crash?

Regards
  David
0
 

Author Comment

by:websss
ID: 39787660
in services the service was stopped
when trying to start i get this error
IMG-17012014-110956.png
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39787662
Hi,

So look in the event viewer at the system log and see what it says.

Look in the SQL instance directory for the log folder, and in there what does errorlog file have?

HTH
  David
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

Author Comment

by:websss
ID: 39787670
here is the log file from sql server
ERRORLOG
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39787676
Hi,

Read the last lines in the error log, then suggest what you should do.

That is, its a text log file, and almost needs to be read from the bottom up.
Did you check the drives and the folder/directory structure?

What version of Windows, and is it suggesting a checkdisk is needed? Has it run a checkdisk?

Regards
  David
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39787679
PS I'm not trying to be difficult, just trying to help your skills

Is this a production server? How serious is this outage?
0
 

Author Comment

by:websss
ID: 39787693
It's the Dev box
But we can't develop now :(
I can see there is an issue with the master db
Do I need to rebuild it?
If so,  how do I do that?
0
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
ID: 39787704
Hi,

I understand. Many dev boxes are actually second tier production - if they are down the developer team is sitting around doing nothing.

For SQL 2012:
Rebuild Master (and msdb and model) databases.
http://technet.microsoft.com/en-us/library/dd207003.aspx

Other versions change the version the drop down on the above.

So the procedure is:
Rebuild the system databases
Restore master
Restore msdb
Check that other databases have now appeared after the restores. If other databases are dodgy then restore from their backups.

Regards
  David

PS Once things are running again, and before you let the dev team at it, I suggest that you stop SQL, and using windows explorer, do a file copy on the 6 system databases files - master, msdb, & model. Then when this happens again, you can simply copy over the actual master files, and hopefully sql will then start. I suggest that you update this off-line copy every time you restart SQL.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 39789666
Good advice from David.

Also, run DBCC CHECKDBs on master, model and msdb, to verify they are completely good from the restore.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS GUID Variable 2 37
T-SQL and CLR parameter strings 9 29
SQL profiler 3 18
Importing cr/lf as text in sql server 7 16
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question