Welcome to EMC Consulting Blogs Sign in | Join | Help

Stuart Preston's Blog

Stuart was CTO for Application Consulting EMEA at EMC Consulting until October 2009, now blogging at http://stuartpreston.net

Team Foundation Server and SQL Server 2005 default database locations.

Another Saturday working, oh well!

Whilst I'm busy installing the Visual Studio 2005 RTM bits, I thought I'd share a helpful hint that can save a bit of time in your TFS setup and improve overall TFS performance if you have more than a single disk in your system.

Immediately after installing SQL Server 2005 with all the recommended options, open your Microsoft SQL Server Management Studio [I do hope you installed the client tools ;)] - connect to your newly created SQL Server 2005 default instance, and in the Object Explorer right click on the SQL Server name > Properties.

Select the Database Settings panel, and update the Database default locations.  In my case, I have a D: and an E: drive on which I put my logs and data files respectively.

Example:

      Data:   E:\MSSQL\data
      Logs:   D:\MSSQL\logs

For these settings to take effect, you need to restart your instance of SQL Server (right click on the SQL Server name > Restart). 

Published 05 November 2005 12:46 by Stuart.Preston

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Marcel de Vries said:

December 10, 2005 21:11

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

I have now left EMC Consulting and can be found at http://stuartpreston.net
Powered by Community Server (Personal Edition), by Telligent Systems