Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving TempDB - SQL School Video Expand / Collapse
Author
Message
Posted Tuesday, November 25, 2008 7:17 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
Comments posted to this topic are about the item Moving TempDB - SQL School Video

Brian Knight
Free SQL Server Training Webinars
Post #608789
Posted Tuesday, December 30, 2008 12:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
Good one...:)


Post #627051
Posted Friday, February 20, 2009 9:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Wednesday, November 18, 2009 5:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, June 21, 2012 1:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 7:49 AM
Points: 16, Visits: 76
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
Posted Saturday, February 2, 2013 7:54 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
Nice..............
Post #1414976
Posted Sunday, February 3, 2013 8:57 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:19 PM
Points: 4,360, Visits: 9,543
touchwithme2 (11/18/2009)
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


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
Posted Sunday, February 3, 2013 9:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,385, Visits: 36,828
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 »

Add to briefcase

Permissions Expand / Collapse