Database not restarting after failure

Asked By shad javier 10 points N/A Posted on - 03/07/2012

Hi ,

We have a database on DB-01 that is running an instance SQL server 2005.

Recently we faced a power outage and it forces to restart the DB-01 which now fails to start SQL server.

How can we restart it.

Please help.

• Status: Open
• Question Views: 801
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Abbot Nimrod

Go To Solution

Answered By Suelto math 0 points N/A #101369

Database not restarting after failure

On another Windows XP computer, install the SQL Server and the latest SP.

 

Install SQL Server on your computer. Copy the Sqlservr.exe and Sqlos.dll files when you reach a part that it fails to start the SQL service from the BINN folder on the successful computer into your own computer.

 

Click Retry and the service should start normally.

 

 

About Suelto math

Questions
2

Answers
10

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Abbot Nimrod 0 points N/A #195092

Database not restarting after failure

Hi there,

It seems as if your database engine files have been corrupted. Your best option is to refresh your database engine files most importantly the sqlserver.exe and the .dll files. 

The best way to do this is to copy the files from a running machine that has the same version of the DB running over to your machine. And then stop and restart the database.

This has nothing to do with your data, only the engine files that run the database seem corrupted.

 

About Abbot Nimrod

Questions
1

Answers
30

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: MS SQL Server