locked
Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    All,

     

    In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.

    When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN), however I am able to start the SQL Server successfully from command line (without any flags).

    Any help is much appreciated.

    Friday, September 24, 2010 9:26 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    In addition to the link provided by Chunsong, you would also need http://support.microsoft.com/kb/953504 in order to change registry entries in clustered environment.

     

    Regards,

    Akim

    Monday, September 27, 2010 9:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    What you are seeing there is a result of registry checkpoint mechanism that we have in clustering.

    If you can make the registry change AFTER bringing the SQL resource online the change will be made permanent in the registry.. if you make the change BEFORE bringing the resource online the new modified entry will be overwritten with the value which exists in the quorum. The supported ways to srevent this check are documented in the KB953504.

     

    Tuesday, September 28, 2010 2:20 AM
    Answerer

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    Please move the Master system database according to Moving the master Database section at Moving System Databases (http://msdn.microsoft.com/en-us/library/ms345408.aspx) on Books Online.

    Thanks,
    Chunsong

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, September 27, 2010 9:49 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    In addition to the link provided by Chunsong, you would also need http://support.microsoft.com/kb/953504 in order to change registry entries in clustered environment.

     

    Regards,

    Akim

    Monday, September 27, 2010 9:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    What you are seeing there is a result of registry checkpoint mechanism that we have in clustering.

    If you can make the registry change AFTER bringing the SQL resource online the change will be made permanent in the registry.. if you make the change BEFORE bringing the resource online the new modified entry will be overwritten with the value which exists in the quorum. The supported ways to srevent this check are documented in the KB953504.

     

    Tuesday, September 28, 2010 2:20 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks a lot for the support. I was able to migrate successfully to the new SAN drive.
    Wednesday, September 29, 2010 12:30 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks a lot for the support. I was able to migrate successfully to the new SAN drive.


    Dear Venu,

    Can you please email me SQL Migration step to new SAN? your help will be much appreciated.

    My email id is sandeep.rohila@hotmail.com


    Tuesday, January 4, 2011 2:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sam,

     

    I sent you an email. Please reply back.

     

    Regards,

    Venu S.

    Venugopal S ----------------------------------------------------------- Please click the Mark as Answer button if a post solves your problem!
    Thursday, January 13, 2011 6:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Venu/Sam,

    Could you please send me the same email about steps to migrate the SQL cluster to new SAN....i badly need the steps...Thanks a lot for the help.

    Send it to sqluser786@live.com

    -Pradeep

    Tuesday, October 23, 2012 6:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Venu/ Sam/Pradeep,

    Could you please send me the steps to migrate the SQL cluster to new SAN.

    We need it ASAP.

    Please send it to :reddys_mca@yahoo.com

    ---Sunny

    Wednesday, October 24, 2012 6:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have prepared a step by step document with screen shots on how to migrate the SAN from existing cluster to new cluster. I did this exercise multiple times on both SQL Server 2005 and SQL Server 2008 so please let me know what issue youa re facing and i will surely be able to help.

    Pradeep & Sunny - email me your contact details and i will send you the list of items to be taken care.

    Please click "Mark as Answer" if the post solves your problem - Thanks

    Thursday, October 25, 2012 4:35 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Venu,

    Can you send it to reddys_mca@yahoo.com.

    --Sunny

    Monday, October 29, 2012 2:49 PM