Marcus N
asked on
SBS 2003 R2 SQL 2005 service won't start after Blue Screen
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?
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?
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
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
ASKER
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?
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?
Where did you install sql server 2005 and its data folder?
ASKER
I've backed up WINDOWS and Program Files. Should I restore both? All the data is in the default SQL location.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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.
"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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had to uninstall and reinstall SQL 2005 in the end.
ASKER
SQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
They won't start.