[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

machine crashed and now sql server wont connect

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
websss
Asked:
websss
  • 5
  • 3
1 Solution
 
David ToddSenior DBACommented:
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
 
websssAuthor Commented:
in services the service was stopped
when trying to start i get this error
IMG-17012014-110956.png
0
 
David ToddSenior DBACommented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
websssAuthor Commented:
here is the log file from sql server
ERRORLOG
0
 
David ToddSenior DBACommented:
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
 
David ToddSenior DBACommented:
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
 
websssAuthor Commented:
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
 
David ToddSenior DBACommented:
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
 
Scott PletcherSenior DBACommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now