SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


i wish to move 'all' data for my teamserver databases to another Drive.


i wish to move 'all' data for my teamserver databases to another Drive.

Author
Message
davidandrews13
davidandrews13
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1815 Visits: 4633
hi there.
i have been doing some research on moving my Team Server Foundation Databases from one Drive, to another, on the same Server.
I am doing this because it is currently on the C Drive, but that drive is incredibly small and i am running out of space.

i found this thread which details the steps i need to take, but needless to say, i am still nervous about following something i have only just found.

http://social.msdn.microsoft.com/Forums/en/tfssetup/thread/b09fcd23-0b65-4e93-82aa-10757d3425af

Edit: for those that dont want to click the link, the steps within are:
1. Stop IIS and the TFS Server Scheduler (windows service)
2. Detach the following databases. From Management Studio, right click on the database - tasks->detach. Do this for the following databases tfsActivityLogging, TFSBuild, TFSIntegration, TFSVersionControl, TFSWarehouse, TFSWorkItemTracking, TFSWorkItemTrackingAttachments.
3. Copy the databases (in step 2) and log files to your new location.
4. Attach the databases (in step 2) and log files
5. Restart IIS and the TFS Server Scheduler (windows service)



i'm looking for your advice, really. do the steps make sense? are there any gotchas that i should be looking out for?
any steps i should be taking, or ensuring are already in place, before starting?

edit: the reason why i have the word 'all' in my Topic Title in inverted commas, is because i'm not quite sure what 'all' the data would be.
i'm going on the assumption that moving everything relating to Team Server will keep things clean and logically placed.

thanks all
george sibbald
george sibbald
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23296 Visits: 13698
I wouldn't go the detach\attach route, rather use the alter database modify file command (see BOL).

stop connections to databases
backup the databases (for safety)
offline databases
run alter database with new physical name to specify new location
COPY the files to the new location
bring databases online
restart services
backup databases and system databases to capture new metadata

once you are happy all is ok delete the database files from the C drive

I see no reason why other TFS files would need to be moved with the database files, in fact probably better they are separate, the database files should be by far the biggest part of the install

---------------------------------------------------------------------
davidandrews13
davidandrews13
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1815 Visits: 4633
thanks for the reply.
i'm going to step through the process you've laid out, and see if it makes sense to me :-D

cheers
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search