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
Solved

SBS 2003 R2 SQL 2005 service won't start after Blue Screen

Posted on 2011-03-12
12
475 Views
Last Modified: 2012-06-27
I had a Blue Screen event on 10 March 2011.

Since rebooting the system none of the SQL services start, nor do any services that have a reliance on SQL (such as my Blackberry Enterprise Server etc).

I have a full system back up from 9 March 2011.

How do I restore the system, including everything to do with SQL, to the 9 March condition? I know how to restore the System State from my NT Backup, but will I have any problems if I also restore the WINDOWS folder and the rest of my OS (C Partition)?

Is there an easier way to restore SQL?
0
Comment
Question by:MarcusN
  • 7
  • 5
12 Comments
 

Author Comment

by:MarcusN
ID: 35115672
In SQL Server Configuration Manager the there are two services with red dots against them, these are:
SQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)

They won't start.
0
 
LVL 11

Expert Comment

by:Paolo Santiangeli
ID: 35115803
Hi,
Sql services should log something in event log about the reasons it dont start however
you can restore system state and then the sql server application and data folders.

have a look here:
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-disaster-recovery.html
0
 

Author Comment

by:MarcusN
ID: 35116563
Thanks, but SQL isn't running. Do I have to uninstall SQL and reinstall, or is there something elseiI can do to repair the application? Can I just recover from the full WINDOWS folder back up of the day before?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 11

Expert Comment

by:Paolo Santiangeli
ID: 35116815
Usually sql server 2005 folder is in Program Files directory not in WINDOWS folder. u should restore it.

Where did you install sql server 2005 and its data folder?



0
 

Author Comment

by:MarcusN
ID: 35116845
I've backed up WINDOWS and Program Files. Should I restore both? All the data is in the default SQL location.
0
 
LVL 11

Accepted Solution

by:
Paolo Santiangeli earned 500 total points
ID: 35116878
you have to look either in system event log and in application event log for SQL errors...

then i should do the following steps:

1. rename the sql folder in program files directory (es. adding an "old")
2. restore ONLY the sql folder in Program files
3. test starting sql service
4. if it doesnt work do a "system state" restore
5. test starting sql service again

0
 

Author Comment

by:MarcusN
ID: 35120456
Thanks. Followed instructions (1) to (5). SQL still won't start. Restored Program Files and System State from the last good back up. Still SQL won't start. Any other ideas?

What are the pros and cons of uninstalling SQL completely and then reinstalling it? What folders and settings do I need to manage in order to have the functionality that I had before the Blue Screen event?
0
 
LVL 11

Assisted Solution

by:Paolo Santiangeli
Paolo Santiangeli earned 500 total points
ID: 35120814
you can unistall it taking care of the data folders the ones which contains mdf and ldf files

are u sure the event logs are not reporting anything avout sql server?
0
 

Author Comment

by:MarcusN
ID: 35121469
There appear to be a lot of log files. Which do I need to look at?

When I attempt to restart the SQL Server (MSSQLSERVER) I now get the following error message.

"Windows could not start the SQL Server (MSSQLSERVER) blah blah... ...refer to service-specific error code 3417."

I've started to look that up on the web but if you have any suggestions, I'd be really keen to hear them.

Thanks, Marcus
0
 

Author Comment

by:MarcusN
ID: 35121622
I'm making a bit of progress with the diagnosis. The last error in the ERRORLOG is;

"Cannot recover the master database. SQL server is unable to run. Restore master from a full backup..."

What confuses me is that I have already done this following your points 1 dnd 2. I'll try again.
0
 
LVL 11

Assisted Solution

by:Paolo Santiangeli
Paolo Santiangeli earned 500 total points
ID: 35122990
well it could be a disk problem,
try to run chkdsk if you didnt do it already

you can also try to install fresh copy of sql server and the attach your dbs
0
 

Author Closing Comment

by:MarcusN
ID: 35127328
Had to uninstall and reinstall SQL 2005 in the end.
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SBS 2011 File Replication Services Question 3 56
aws pricing 2 60
SBS 2008 RDP Gateway works on from Windows 10 5 39
SBS 2011. One user has no X400 email address 4 47
Finally comes the third version of VMware Virtual SAN, whose name is 6.1, and comes loaded with new features many of which really are excellent and even surprising.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

790 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