Solved

machine crashed and now sql server wont connect

Posted on 2014-01-16
9
559 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
  • 5
  • 3
9 Comments
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:websss
Comment Utility
here is the log file from sql server
ERRORLOG
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 35

Expert Comment

by:David Todd
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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:ScottPletcher
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now