TfsActivityLogging
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 1,
MOVE 'TfsActivityLogging' to '<DataFileLocation> \TfsActivityLogging.mdf ",
MOVE 'TfsActivityLogging_log' '<LogFileLocation> \TfsActivityLogging_log.ldf '
RESTORE DATABASE TfsBuild
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 2,
MOVE 'TfsBuild' '<DataFileLocation> \TfsBuild.mdf",
MOVE 'TfsBuild_log' '<LogFileLocation> \TfsBuild_log.ldf '
RESTORE DATABASE TfsIntegration
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 3,
MOVE 'TfsIntegration' to '<DataFileLocation> \TfsIntegration.mdf ",
MOVE 'TfsIntegration_log' '<LogFileLocation> \TfsIntegration_log.ldf '
RESTORE DATABASE TfsVersionControl
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 4,
MOVE 'TfsVersionControl' '<DataFileLocation> \Tfs_ <TeamProjectCollectionName> .mdf",
MOVE 'TfsVersionControl_log' '<LogFileLocation> \Tfs_ <TeamProjectCollectionName> _log.ldf '
RESTORE DATABASE TfsWorkItemTracking
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 5,
MOVE 'TfsWorkItemTracking' '<DataFileLocation> \TfsWorkItemTracking.mdf ",
MOVE 'TfsWorkItemTracking_log' '<LogFileLocation> \TfsWorkItemTracking_log.ldf '
RESTORE DATABASE TfsWorkItemTrackingAttachments
FROM Disk = 'C:\TFS 2008 Upgrade.bak'
,
,
FILE = 6,
MOVE 'TfsWorkItemTrackingAttachments' to '<DataFileLocation> \TfsWorkItemTrackingAttachments.mdf",
MOVE 'TfsWorkItemTrackingAttachments_log' '<LogFileLocation> \TfsWorkItemTrackingAttachments_log.ldf '