February 17, 2005 at 12:18 pm
I've just stopped my service so I could do a bit of maintenance on my main machine...
however the worrying thing is that now when I go to restart it comes up with the following error message: "the system cannot find the path specified"
This has completley thrown me. I was deleting old user files and not going anywhere near my SQL databases. Does anyone have any clue why this might be? I've searched Microsoft support and can't find anything with this error.
February 17, 2005 at 12:54 pm
You got a broken path by deleting file from your server.
'my computer' right click->property-> advance tab ->environment variables->system variable section-> look for 'path'->edit
copy and past your path to a note pad and verify that each path exist on the sytem otherwise remove it out from the sytem.
I would also advise that you talk to your server people if your company is large enough. Remember to save your old path to a file someone that you have access in case you need to reuse it... any way that old path no longer is that usufull in your case.
good luck.
mom
February 17, 2005 at 1:16 pm
can you try to execute sqlservr.exe directly from the command prompt and see if sql services starts or not ? The .exe canbe found under \microsoft SQL Server\MSSQL\Binn\
February 17, 2005 at 1:56 pm
Cheers for the help guys.
When I run it from the command prompt it still fails.
The interesting thing is the path though. That's actually intact, though it is duplicated in there twice. A while ago one of my colleagues installed some software that installed a new instance of SQL server with it. He then uninstalled it. I'm guessing this is where the duplicate path is. Could a dirty uninstall be causing me these problems?
February 17, 2005 at 3:54 pm
No need to worry anymore... I just rebuilt the SQL server installation and went a bit crazy with sp_attach_db.
Everything is up and running.
February 17, 2005 at 7:54 pm
That's good. Just curious. Why do you need to shut down sql to perform maintenance on your system ?
February 18, 2005 at 8:01 am
I was removing a few old programs that haven't been used for years and tiding up our user directories. Had to do a reboot of the server, hence stop SQL.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply