June 21, 2012 at 12:42 pm
I apologize if this is not the correct forum.
I have one last SQL Server 2000 machine that I look after. I needed to move the system databases and I did master last. I right-clicked on the server in EM, selected properties, then clicked on Startup Parameters. I changed the three parameters, moved the data files, and started the service--which immediately failed. I checked out the settings in the registry and they are:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
"SQLArg0"="-dS:\\master.mdf"
"SQLArg1"="-eS:\\mastlog.log"
"SQLArg2"="-eS:\\ERRORLOG"
As you can see, I used the wrong switch for the transaction log. I tried changing the value in the registry, but it gets overwritten when I attempt to start the service, so it must actually be stored somewhere else. Does anyone know how I can fix this without rebuilding the server?
TIA,
Alex
June 21, 2012 at 2:39 pm
I'm not sure if you are using an unconventional extension on the log file but SQL database log files use .ldf not .log. It looks like you have an extra backslash in each one also.
Try setting the reg keys to:
"SQLArg0"="-dS:\master.mdf"
"SQLArg1"="-lS:\mastlog.ldf"
"SQLArg2"="-eS:\ERRORLOG"
Instead of:
"SQLArg0"="-dS:\\master.mdf"
"SQLArg1"="-eS:\\mastlog.log"
"SQLArg2"="-eS:\\ERRORLOG"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply