Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

i wish to move 'all' data for my teamserver databases to another Drive. Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 3:54 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 616, Visits: 3,578
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
Post #1422486
Posted Thursday, February 21, 2013 8:21 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:38 AM
Points: 5,888, Visits: 13,060
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


---------------------------------------------------------------------

Post #1422623
Posted Thursday, February 21, 2013 9:00 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 616, Visits: 3,578
thanks for the reply.
i'm going to step through the process you've laid out, and see if it makes sense to me

cheers
Post #1422654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse