Emergency 
Author Message
 Emergency
We hope you could help us.

When we got here this morning, SQL Server 2000 was not
responding in any way - Enterprise Manager, Vb apps, ASP,
etc.

In Enterprise Manager, everything expands, EXCEPT FOR THE
DATABASES TAB.

There are no error messages or logs. We are afraid that if
we reinstall the SQL Server, we will lose all the
databases and data since there's no way for us to detach
them.

HELP!!!!

R. Petrov
A. Beuhring
National Asset Management



Tue, 27 Sep 2005 15:40:35 GMT
 Emergency

| We hope you could help us.
|
| When we got here this morning, SQL Server 2000 was not
| responding in any way - Enterprise Manager, Vb apps, ASP,
| etc.
|
| In Enterprise Manager, everything expands, EXCEPT FOR THE
| DATABASES TAB.
|
| There are no error messages or logs. We are afraid that if
| we reinstall the SQL Server, we will lose all the
| databases and data since there's no way for us to detach
| them.

I am not recommending anything - I am new too.  I am guessing someone else who knows what they are doing will want to know, so I am
just trying to speed things up.

Have you rebooted the box, or stopped/start the service?

Carl K



Tue, 27 Sep 2005 15:51:27 GMT
 Emergency
Have you tried restarting the SQL Server service, restrating the box?  What
does task manager say is going on?  Is the CPU or network activity through
the roof?


Quote:
> We hope you could help us.

> When we got here this morning, SQL Server 2000 was not
> responding in any way - Enterprise Manager, Vb apps, ASP,
> etc.

> In Enterprise Manager, everything expands, EXCEPT FOR THE
> DATABASES TAB.

> There are no error messages or logs. We are afraid that if
> we reinstall the SQL Server, we will lose all the
> databases and data since there's no way for us to detach
> them.

> HELP!!!!

> R. Petrov
> A. Beuhring
> National Asset Management



Tue, 27 Sep 2005 15:49:54 GMT
 Emergency

Quote:
>-----Original Message-----
>Have you tried restarting the SQL Server service,

restrating the box?  What

Quote:
>does task manager say is going on?  Is the CPU or network
activity through
>the roof?



>> We hope you could help us.

>> When we got here this morning, SQL Server 2000 was not
>> responding in any way - Enterprise Manager, Vb apps,
ASP,
>> etc.

>> In Enterprise Manager, everything expands, EXCEPT FOR
THE
>> DATABASES TAB.

>> There are no error messages or logs. We are afraid that
if
>> we reinstall the SQL Server, we will lose all the
>> databases and data since there's no way for us to detach
>> them.

>> HELP!!!!

>> R. Petrov
>> A. Beuhring
>> National Asset Management

>.

Yes, we tried all that. It does not work.


Tue, 27 Sep 2005 16:20:41 GMT
 Emergency

Quote:
> Yes, we tried all that. It does not work.

What do you mean, you "tried all that"?  I asked a couple of questions.  Is
sqlservr.exe using all the CPU?  Is your network activity very high?

Also, what service pack is the server at (both Windows and SQL Server)?



Tue, 27 Sep 2005 16:26:41 GMT
 Emergency
We fixed it! It was a corrupted database. I renamed
the .mdf file and voila! They are gonna determine what's
wrong with that particular database.

Thanks for the responses.

Quote:
>-----Original Message-----
>Have you tried restarting the SQL Server service,

restrating the box?  What
Quote:
>does task manager say is going on?  Is the CPU or network
activity through
>the roof?



>> We hope you could help us.

>> When we got here this morning, SQL Server 2000 was not
>> responding in any way - Enterprise Manager, Vb apps,
ASP,
>> etc.

>> In Enterprise Manager, everything expands, EXCEPT FOR
THE
>> DATABASES TAB.

>> There are no error messages or logs. We are afraid that
if
>> we reinstall the SQL Server, we will lose all the
>> databases and data since there's no way for us to detach
>> them.

>> HELP!!!!

>> R. Petrov
>> A. Beuhring
>> National Asset Management

>.



Tue, 27 Sep 2005 16:47:51 GMT
 Emergency
Bring the seerver up in safe mode (this will not start the SQL Server
service).  Back up your data files (*.mdf, *.ldf, *.ndf).

I would set SQL Service statup in teh services manager to manual and
then restart the server.  Restart the server and see if you can then
manually start the DB.  Before you do check the event logs for any
messages.

Quote:

> We hope you could help us.

> When we got here this morning, SQL Server 2000 was not
> responding in any way - Enterprise Manager, Vb apps, ASP,
> etc.

> In Enterprise Manager, everything expands, EXCEPT FOR THE
> DATABASES TAB.

> There are no error messages or logs. We are afraid that if
> we reinstall the SQL Server, we will lose all the
> databases and data since there's no way for us to detach
> them.

> HELP!!!!

> R. Petrov
> A. Beuhring
> National Asset Management



Tue, 27 Sep 2005 19:13:48 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. emergency restore

2. Help ! Emergency Repair

3. How to do a emergency restore / backup?

4. EMERGENCY: SQL 7 Server Down

5. Emergency help needed

6. *Emergency Help Needed!

7. Help ! Emergency Repair

8. I need emergency help

9. Help on SQLServer 6.5 Distributed Transaction Coordinator(Emergency)

10. EMERGENCY...Please help.

11. Emergency: Replication Deleted Everything.


 
Powered by phpBB® Forum Software