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.