Here is the story so far..
My NT box decided it was time for Blue screen of Death. However I was able to do a REPAIR of the NT, using the NT CD and R option, and now I am able to Boot.
My system: Compaq AP550
9.1GB SCSI HD - OS and SQL server
120 GB IDE HD - SQL DATA
After logging into NT, I get this error from
SQL server service manager:
"The specified Service does not exist as an Installed Service"
I go into SQL server enterprise manager and double click on the <server name> SQL server This is what I get:
A connection could not be established to <sever name>
Reason : SQL Server does not exist or access denied
ConnectionOpen (Connect()):
HOw can I get my SQL server up again. I am new to SQL server and new to this machine, just been asked to fix it.
My main concern is really the data residing on the IDE drive. There are couple of databases 30 GB and 65GB. I need to be able to back them upto another hard drive before this machine dies on us. We are moving to a Dell Poweredge server, and SBS 2003.
SO the final result we are looking at is to have these databases onto that new machine. I am hoping if I can fix/repair the SQL server on this old machine, and get it up and running, then I can back up the databases to a new Hard Disk. And use that disk in the New machine to restore them on the SBS 2003 box.
Any comments or suggestions on how to go abou this would be very appreciated.
Thanks
Kode
My NT box decided it was time for Blue screen of Death. However I was able to do a REPAIR of the NT, using the NT CD and R option, and now I am able to Boot.
My system: Compaq AP550
9.1GB SCSI HD - OS and SQL server
120 GB IDE HD - SQL DATA
After logging into NT, I get this error from
SQL server service manager:
"The specified Service does not exist as an Installed Service"
I go into SQL server enterprise manager and double click on the <server name> SQL server This is what I get:
A connection could not be established to <sever name>
Reason : SQL Server does not exist or access denied
ConnectionOpen (Connect()):
HOw can I get my SQL server up again. I am new to SQL server and new to this machine, just been asked to fix it.
My main concern is really the data residing on the IDE drive. There are couple of databases 30 GB and 65GB. I need to be able to back them upto another hard drive before this machine dies on us. We are moving to a Dell Poweredge server, and SBS 2003.
SO the final result we are looking at is to have these databases onto that new machine. I am hoping if I can fix/repair the SQL server on this old machine, and get it up and running, then I can back up the databases to a new Hard Disk. And use that disk in the New machine to restore them on the SBS 2003 box.
Any comments or suggestions on how to go abou this would be very appreciated.
Thanks
Kode