Geeks With Blogs
Mike Azocar So long and thanks for all the Fish!
I have been installing Team Foundation Server since Beta 2, so I have seen the installation go from very difficult to quite easy. One issue that we came across at my client site was that the default installation put all of the sharepoint and vsts databases on the system partition (aka C: drive). To fix this is a simple task.
  1. Login to the SQL Server 05 Management Studio as an Administrator.
  2. Expand the database folder.
  3. Right click on each of the following databases and select Tasks | Take offline: ReportServer, ReportServerTempDB, STS_Config_TFS, STS_Content_TFS, TfsActivityLogging, TfsBuild, TfsIntegration, TfsVersionControl, TFSWarehouse, TfsWorkItemTracking, and TfsWorkItemTrackingAttachments. If you are unable to take these databases offline, in the Management Studio expand the Management folder and double click on the Activity Monitor node. Right click on any processes attached to your database and select kill (you will need to refresh the screen after each). Once all of the processes are killed you should be able to go offline.
  4. Right click on each of the databases listed in step 3 and select Tasks | Detach.
  5. Open Windows Explorer and navigate to the folder where SQL server stores the ".mdf" and ".ldf" files (usually in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).
  6. Copy each ".ldf" and ".mdf" for each of the databases listed in step 3 to a new location on another drive.
  7. Back in Management Studio, right click on the server node and select Refresh.
  8. Right click on the Database folder and select Attach for each of the databases listed in step 3. The Attach Databases screen will be displayed.
  9. Click on the Add button and navigate to the new location selected in step 6.
Happy Coding! Posted on Friday, May 26, 2006 1:05 PM Administration | Back to top

Comments on this post: Moving VSTS Databases

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Mike Azocar | Powered by: