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
Go To Solution
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.
 

 

About Suelto math
Questions
2
Answers
10
Best Answers
1
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.

 
About Abbot Nimrod
Questions
1
Answers
30
Best Answers
23

Spiral code for java using recursion

Previous

Infrastructure master and global catalog(AD)

Next

Related Questions