February 29, 2012 at 1:06 pm
Hi All,
My current system OS 2K8 R2 Ent 64bit 512gb RAM and SQL 2K5 64bit Ent SP4, its an active\active cluster config. I need to relocate system db's from the default install of which I did with model, temp & msdb no issue.
Now i need to do the same with master and resource db, i followed the instruction from MSDN site on how to http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx
I get to step 7 to start SQL using NET START MSSQL$instance /f /T3608 from the command shell running it as an administrator, i get an error sql failed to start.
Interesting enough, when i want to revert back to the default path that is step 4 the top part b4 the below change were my original files at, changing startup parameters, it fails once again and changes back to the wrong startup settings
Any ideas
It's better to fail while trying, rather than fail without trying!!!
February 29, 2012 at 4:23 pm
you are trying to start the instance from the system32 directory, you need to change directory to the correct bin location path before issuing the start command!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 2:14 am
Hi
Tested it on the other and starts fine whether systems 32 folder or binn folder
It's better to fail while trying, rather than fail without trying!!!
March 1, 2012 at 3:40 am
yes, you're starting the service thats why. I prefer to run the exe directly by changing to the Bin path for the instance i wish to start and then executing
SQLSERVR.EXE -f -T 3608
you will generally get better output to the screen to see what the issue is, have you tried looking through the event log to see if there is an error there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 3:52 am
on the very same server, without changing the startup parameters it works ok, c attached
Now i'm not sure why
It's better to fail while trying, rather than fail without trying!!!
March 1, 2012 at 3:56 am
What error do you get in error log?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply