Temp Db to be moved (urgent ) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Temp Db to be moved (urgent )

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
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.
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
May be you are asking about cluster.log which is in c:WINDOWSClustercluster.log
MohammedU.
Moderator
SQL-Server-Performance.com
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.
Hi Satya&MohammedU
Thanks this is what i am looking for. Bye,
Srinivas.Sista
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

]]>