Moving TempDB - SQL School Video

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Moving TempDB - SQL School Video

Moving TempDB - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Tuesday, November 25, 2008 7:17 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the item Moving TempDB - SQL School Video

Brian Knight
Free SQL Server Training Webinars

Post #608789

Anipaul

Posted Tuesday, December 30, 2008 12:04 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

Good one...:)

Post #627051

maurine

Posted Friday, February 20, 2009 9:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 11, 2010 8:27 AM
Points: 98, Visits: 48

Thanks, Brian. Very easy to understand and follow based on your presentation.

Post #661405

touchwithme2

Posted Wednesday, November 18, 2009 5:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 19, 2010 3:54 AM
Points: 1, Visits: 6

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 Regards
Eswari.S

Post #820733

Shane Clarke

Posted Thursday, June 21, 2012 1:26 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 07, 2013 12:12 AM
Points: 16, Visits: 61

Hi

Thanks. 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?

Thanks
Shane

Post #1319127

dineshvishe

Posted Saturday, February 02, 2013 7:54 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:41 AM
Points: 61, Visits: 297

Nice..............

Post #1414976

Jeffrey Williams 3188

Posted Sunday, February 03, 2013 8:57 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:13 PM
Points: 4,319, Visits: 9,217

touchwithme2 (11/18/2009)

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.

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Post #1415022

GilaMonster

Posted Sunday, February 03, 2013 9:15 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 38,091, Visits: 30,385

Shane Clarke (6/21/2012)

How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?

Same way. No, just once. The settings are stored in master and master will be on shared storage.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1415023

« Prev Topic | Next Topic »

Permissions