Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2000 Stopped working, possible after Backup Exec Backup

Posted on 2010-11-10
6
Medium Priority
?
701 Views
Last Modified: 2012-05-10
Hi there,

Unfortunately a Database server has stopped working. The issue appears to be that the Service will not start. When entering the SQL Management tool it tries to connect to the Server (local) and says:
'A connection could not be established to SERVER1,  Reason: SQL Server does not exist or Access denied

When attempting to start the service it appears to start but if you refresh it will no longer be started.

Yesterday i was running some backups using backup exec and encountered some issues. It stated in the failed backup that some databases (which have not been used in years) are in restore mode. I ignored this, then last night I decided to restart the server. Since not long after that restart the logs are full (overnight) with error logs about the MSSQL.

Unfortunately i've turned this server off and are cloning it before I commence a reinstall of SQL Server 2000. I'm in a little bit of unchartered territory as i've not reinstalled SQL onto an existing broken install and I also did not set this up in the first place.

Any ideas would be good and I should be able to provide logs soon.

Cheers
0
Comment
Question by:lemonville
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 1

Author Comment

by:lemonville
ID: 34108704
I've now reinstalled SQL Server 2000. (but i've duplicated the server just in case).

I've reattached the databases. However still no go. Sharepoint doesn't work, has the following error: "Cannot connect to the configuration database."

IN the logs, there is repeated error messages every 30 seconds or so. the source is Windows Sharepoint Services 3. And the Error description is:

'Unknown error information from SQL Server is included below.

A connection was successfully established with the server, but then an error occuring during the login process. (provider: Named Pipes Provider, errorL 0 - No process is on the other end of the pipe.)

0
 
LVL 1

Accepted Solution

by:
lemonville earned 0 total points
ID: 34109494
Looks like I resolved the issue. i went back to the existing server, looked through the logs. and there was commonly: 'Database 'model' cannot be operned. It is in the middle of a restore"
I ran through this: http://support.microsoft.com/kb/822852 and it fixed it!

However, now the system is running at an extremely slow pace. 10 - 30 seconds to load a page.

Logs show nothing. Any ideas?
0
 
LVL 7

Expert Comment

by:rmm2001
ID: 34128831
It doesn't really answer your question..but backup your system databases. It makes life much easier when they do that. ...and yes - the 2nd time it happened to me I wondered why I didn't do it after the first time.

Have you tried restarting the service again?

Try running dbcc checkdb on your database to see if there's anything suspicious happening
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 38

Expert Comment

by:Jim P.
ID: 34129864
>> Named Pipes Provider, errorL

Named pipes has been a nightmare since inception. You should have a SQL configuration manager. Turn oof named pipes and then restart all SQL Services.
0
 
LVL 1

Author Comment

by:lemonville
ID: 34158496
Forgot to mention. After a few hours the speed went back to normal gradually.

All good ! :)
0
 
LVL 1

Author Closing Comment

by:lemonville
ID: 34186412
Managed to resolve it.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question