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 «««123

Setting SQL Server Default Locations Expand / Collapse
Posted Wednesday, November 16, 2011 5:56 AM



Group: General Forum Members
Last Login: Today @ 9:37 PM
Points: 5,911, Visits: 10,366
Just restart the SQL Services.

If you set the directories from the GUI, then those keys will be built for you.

When writing this article, I didn't consider clustered instances. They may go somewhere else... I'll try to find some time to investigate.

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 #1206604
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse