I have had to restore a Windows 2000 server from backup tape using Veritas Backup Exec 9.1. I have two hard drive partitions (C and T). Since restoring both partitions and the system state I am now receiving the following problems. I am running Windows 2000 Standard Server and SQL 2000.
Windows Services displays the following
SQLServerAgent - will not start at all
MSSQLServer - is in stopping state
MSSQL$Redmap - is in stopping state
BackupClientSvc - is in stopping state
Enterprise Manager lists both SQL databases (Local and DT2000Server\Redmap) however both are stopped and showing Connection Failed, check SQL Server Registration Properties.
I have found that I do not have any .BAK files for the above databases, however I do appear to have the corresponding mdf and ldf files if that is of any help in restoring.
Any help with getting these databases up and running again would be appreciated.