SQL Server Performance

Temp Db to be moved (urgent )

Discussion in 'SQL Server Clustering' started by sns_subash2002@yahoo.com, Feb 27, 2007.

  1. Hi All,

    I want to move tempdb physical files to different drive. I used the below code to move the file after running i got saying that the file are moved after that i have given reboot to the server with out moving the file manually to the new location and renaming the copy of the files with different name.
    I tired 2 way manually copied the files and to the new location and given a reboot to the serever the SQL Server was not up and at the same time i have moved the fies to the old location(cut and past) and reboot the server but the SQL Server was not up.
    I want my SQLServer to be up want need to be done can any one help me the cod and the error log message is as below.
    use master
    go
    Alter database tempdb modify file (name = tempdev, filename = 'E:Sqldata empdb.mdf')
    go
    Alter database tempdb modify file (name = templog, filename = 'E:Sqldata emplog.ldf')
    goFCB::Open failed: Could not open file P:MSSQL$DEMO1Tempdb empdb.mdf for file number 1. OS error: 2(The system cannot find the file specified.).

    Thanks,
    Srinivas Sista
  2. satya Moderator

    In SQL Server error log only in addition to the event viewer logs.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. Hi Satya,

    That is fine, but there is on folder in(d:mssqll...) which you find a file(Just like error log in log folder) that talke a lot why the cluter was down/what is the error and all..

    I am looking for that file.


    THanks,
    Srinivas.Sista
  4. MohammedU New Member

    May be you are asking about cluster.log which is in c:WINDOWSClustercluster.log


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  5. satya Moderator

    Whatever it is you can find from event log anyway, if for specific then yes that path is suitable.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. Hi Satya&MohammedU


    Thanks this is what i am looking for.

    Bye,
    Srinivas.Sista
  7. Hi Satya,
    I have Q? if you have 2 node cluster and 2 node instance it is and each node is hosting one SQ LServer now how do you find that which one is the primary and which is the seconday.
    Thanks,
    Srinivas Sista

Share This Page