SQL Server Performance

tempdb location change - sql not coming online

Discussion in 'ALL SQL SERVER QUESTIONS' started by amara, Aug 1, 2012.

  1. amara Member

    We have a newly built cluster environment and there is a dedicated disk for the tempdb.
    Unfortunately, after the setup, I forgot to put tempdb in that drive.
    so customer himself tried moving it.
    Without that disk "S" being added as dependency to SQL Server resource in the cluster, customer tried to move tempdb and restarted SQL Server.
    Now, SQL Server is not coming online as tempdb doesnt really exist anywhere.

    Can someone help me fix this issue ASAP
  2. Shehap MVP, MCTS, MCITP SQL Server

    As per my understanding from your incident description , it sounds like you tried to move temp DB to some other location on a SAN LUN not exists within cluster resources of your SQL instance ,..

    Therefore , I do prefer to add this SAN storage to cluster resources and assign its existence within SQL Service dependency them restart your SQL Service..

    Kindly note that if you are using SQL Server 2005 cluster , you will have to bring your SQL Service offline to add this SAN LUN then you can bring it back online again

    Kindly work out it and let me know your feedback

Share This Page