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 @ 11:20 PM
Points: 45,441, Visits: 43,800
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 @ 6:20 PM
Points: 5,907, Visits: 10,322
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