May 4, 2005 at 10:06 am
I've cloned my production server to a standby server. When I try and start the SQL services, I get a message stating "path not found". I checked the paths as defined in the registry and they appear accurate. Event viewer doesn't give any more detail than the message I receive when trying to start the services. It's not logging anything to the SQL log files. Does anyone have any additional ideas as to where I should be looking? Again, it doesn't state a path or file name so I'm stumped at this point. Perhaps reinstalling is my only option? TIA
Terry
May 4, 2005 at 10:08 am
How did you cloned the server?
May 4, 2005 at 10:43 am
NTBACKUP
Terry
May 4, 2005 at 2:51 pm
does the clone server has the same hard drive structure as your production server? has to be same otherwise you will receive that error message
May 4, 2005 at 2:54 pm
That was one of the first things I checked. That's what's confuses me since I've done this process in the past and it's never failed before.
Terry
May 4, 2005 at 3:42 pm
Hello,
Path not found to what? To Master Database? Please, let us know when do you get this message. You may also check the Event log with all messages, but in particular check SQL Server Error logs. Is one being created when you try to start a server? Or it does not go that far in its startup?
Did you try to start it from the command line with minimal configuration? This is -f option
SQLSERVR.EXE -f
You may want to take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_8m43.asp
"Using Startup Option" There also some options to specify path. Try it and let us know.
I am sure you checked it, but just in case, if when the backup was done SQL Server service was up then no database files will go to the backup.
Check that Master database file exists.
Yelena
Regards,Yelena Varsha
May 5, 2005 at 9:44 am
If never states what the path is or what it's looking for. The event viewer says the same thing "Path not found", nothing more. I'll try your suggestion with the -f flag.
Terry
May 5, 2005 at 10:45 pm
Terry,
Does the account used for the MSSQLServer service have modify rights to the root drive that the data files are stored on? I have had a similar problem before where SQL starts then dies opening tempdb - file not found....
Final fix was to grant modify rights to the service account.
Glenn
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply