Database not restarting after failure

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Abbot Nimrod
Answered By 0 points N/A #101369

Database not restarting after failure

qa-featured

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.
 

 

Best Answer
Best Answer
Answered By 0 points N/A #195092

Database not restarting after failure

qa-featured

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.

 

Login/Register to Answer

Related Questions