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: Yesterday @ 3:01 PM
Points: 44,597, Visits: 42,322
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: Yesterday @ 8:48 AM
Points: 5,788, Visits: 10,127
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