February 10, 2006 at 12:24 pm
Hi,
I accidentally deleted the path of the master database in the startup parameter and the errorlog. I stopped the sql server and now I am unable to start the sql server. I even tried to change the start up parameter in the registry its not working let me know how to start now?
with smiles
santhosh
February 13, 2006 at 3:23 am
You may try more other options
- Restart the server, start the sql server via EM
- Look at the services and try starting all sql related services
- Try detach/attach master db.
Hope it helps !
Rgds, A
February 13, 2006 at 7:20 am
You'll need to know the current path to your Master DB and error log files. You can then issue the following from a command prompt:
sqlservr [-sinstance_name] [-dmaster_path]
[-eerror_log_path] [-lmaster_log_path]
If you're using a default instance, you can omit the instance name parameter.
My hovercraft is full of eels.
February 13, 2006 at 9:37 am
It sounds as if you were 'playing' with regedit (which can be quite dangerous). In order to fix things you will need to perform a Windows search to find the fully qualified path of master.mdf, mastlog.ldf and errorlog. (you have to put the period after the errorlog for the search to work). Once you have the information you'll need to go back into regedit and add/check the following registry keys (I am assuming a default instance):
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/MSSQLServer/Parameters
The SQLArg's should look something like this:
SQLArg0 REG_SZ -dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf
SQLArg1 REG_SZ -eC:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG
SQLArg2 REG_SZ -lC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
Hope that this helps.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 13, 2006 at 9:44 am
Thanks guys, I ended up finally in editing the registry using regedit, adding the startup paramater manually and then successfully started my database. The earlier problem was like when I edited the registry for the first time it was like i gave a wrong path in the parameter key entery.
with smiles
santhosh
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply