Welcome to blogs.conchango.com Sign in | Join | Help

Welcome to blogs.conchango.com

Stuart Preston's Blog

Stuart is CTO for Application Consulting EMEA at EMC Consulting.

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
Powered by Community Server (Personal Edition), by Telligent Systems