Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Starting SQL without TempDB Expand / Collapse
Posted Saturday, March 19, 2011 7:05 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
For those DR situations where the TempDB drives are missing/failed and won't be replaced soon. How to start SQL without TempDB and how to move the files to a new location.

I'll take this one also, again not in the next couple months.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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 #1080839
Posted Saturday, March 19, 2011 6:16 PM



Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 5,911, Visits: 10,368
Sounds interesting. Looking forward to seeing this one - hurry up, will you

Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1080931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse