InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:12:20 GMT20http://www.sqlservercentral.com/Forums/Topic608789-31-1.aspx[quote][b]Shane Clarke (6/21/2012)[/b][hr]How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?[/quote]Same way. No, just once. The settings are stored in master and master will be on shared storage.Sun, 03 Feb 2013 09:15:52 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic608789-31-1.aspx[quote][b]touchwithme2 (11/18/2009)[/b][hr]Hi,It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.Plz update on this ....Waiting for your reply.Thanks and RegardsEswari.S[/quote]No, you cannot move the tempdb (or any database files) without an outage. For normal databases, moving the files just requires that database to be offline. For system databases, moving the files requires a restart (at a minimum) of SQL Server.For tempdb, you can make the changes to the system tables at any time - then at the next restart of SQL Server the files will be created in the new location. Be aware that if you make a mistake on the path for tempdb (e.g. typo in the directory name) - SQL Server will not start and you will have to start SQL Server in single-user mode to fix.Sun, 03 Feb 2013 08:57:54 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxNice..............Sat, 02 Feb 2013 19:54:21 GMTdineshvishehttp://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxHiThanks. Easy and straight to the point. How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?ThanksShaneThu, 21 Jun 2012 01:26:37 GMTShane Clarkehttp://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxHi,It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.Plz update on this ....Waiting for your reply.Thanks and RegardsEswari.SWed, 18 Nov 2009 05:35:16 GMTtouchwithme2http://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxThanks, Brian. Very easy to understand and follow based on your presentation.Fri, 20 Feb 2009 09:10:40 GMTmaurinehttp://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxGood one...:)Tue, 30 Dec 2008 00:04:35 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic608789-31-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Video/65074/">Moving TempDB - SQL School Video</A>[/B]Tue, 25 Nov 2008 19:17:47 GMTBrian Knight