Can TFS installatino tell SQL where to put the database files.

I plan on installing TFS server and SQL server on the same virtual server. The server has limited disk space so I need to put the database files on a SAN.

Is it possible to tell the TFS installer to put the database files in a specfic location that is different then where SQL Server would normally place new database files? If not is there a way to tell SQL server to put all new database files in a specific location other then the normal default locations?

Thanks

-- Steven

[509 byte] By [StevenIBSI] at [2008-1-8]

«« Proxy error in Windows Vista
»» My understanding on LINQ

# 1

TFS cannot tell SQL where to put the database files, but you can.

I am no SQL expert, but I think the simplest way to accomplish this is to install TFS and let SQL put the TFS databases in the default location.

Then open SQL Management Studio, and for each of the 7 TFS databases:

1) right click on Properties to get the path of the database files

2) right click and select Detach.

Next move the .mdf and .ldf files to wherever you want to put them.

Then go back into SQL Management Studio and add the databases back in. I think you do that by right clicking to on the instance and selecting "Attach database."

WillLennon-MSFT at 2007-10-2 >

top of Msdn Tech,Visual Studio Orcas,Visual Studio Orcas Install and Setup...

# 2

Thats what I wanted to avoid doing. Turns out SQL allows you to set a default location for where the database files are created. In SQL management studio you right click on the server and drill down into the database properties to set this.

StevenIBSI at 2007-10-2 >

Visual Studio Orcas

Visual Studio Orcas Install and Setup

Visual Studio Orcas Hot Topic

Visual Studio Orcas New Topic

Visual Studio Orcas

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech