SQL 2005 Clustering issues

  • 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!!!

  • 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" 😉

  • 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!!!

  • 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" 😉

  • 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!!!

  • What error do you get in error log?


    Sujeet Singh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply