StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Thanks to @Edward for his advice which made complete sense. Unfortunately on looking into doing this, I discovered that TFS 2005 is not supported on Windows Server 2008 so I couldn't do it that way round.</p> <p>I ended up doing what I initially suggested (in place upgrade and then migration). I have listed the steps below in case anyone else ever wants to do this. Please note that these steps are in no way exhaustive but they are the general process you need to follow with pointers to the correct documentation.</p> <p><strong>New server:</strong></p> <ol> <li>Set up Windows Server 2008</li> <li>Install prerequisites (IIS, SQL 2008) according to the <a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15743" rel="nofollow">TFS 2008 installation guide</a></li> <li>Merge the TFS 2008 installation files with TFS 2008 SP1 in order to support SQL 2008 <a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15743" rel="nofollow">(same installation guide)</a></li> <li>Install TFS 2008 SP1 <a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15743" rel="nofollow">(same installation guide)</a></li> <li>Upgrade SQL 2008 to SP2 to fix a bug which prevented maintenance plans from running without SSIS</li> <li>Back up TFS and SharePoint databases</li> <li>Back up the SSRS encryption key</li> </ol> <p><strong>Old server:</strong></p> <ol> <li>Take image of server for backup</li> <li>Stop TFS/IIS services for robust database backup</li> <li>Back up TFS and SharePoint databases</li> <li>Back up the SSRS encryption key</li> <li>Verify SQL 2005 SP1 is installed to support TFS 2008</li> <li>Upgrade TFS 2005 > TFS 2008 as per <a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15743" rel="nofollow">TFS 2008 installation guide</a></li> <li>Install TFS 2008 SP1 to support SQL 2008</li> <li>Back up TFS and SharePoint databases</li> <li>Back up the SSRS encryption key</li> <li>Upgrade SQL 2005 > SQL 2008 as per <a href="http://msdn.microsoft.com/en-us/library/ee175815%28v=vs.90%29.aspx#c304e51f-52a5-4f06-a34a-798c6f38a4aa" rel="nofollow">MSDN guide</a></li> <li>Back up TFS and SharePoint databases</li> <li>Back up the SSRS encryption key</li> <li>Upgrade Windows SharePoint Services 2.0 > WSS 3.0 (new server is Windows Server 2008 which only supports 3.0) as per <a href="http://msdn.microsoft.com/en-us/library/cc507614%28v=vs.90%29.aspx" rel="nofollow">MSDN guide</a></li> <li>Install SQL 2008 SP2</li> <li>Perform TFS migration as per <a href="http://msdn.microsoft.com/en-us/library/ms404869%28v=VS.90%29.aspx" rel="nofollow">MSDN guide</a></li> </ol> <p>I tried this all out first on some disposable virtual servers which was very worthwhile. The whole process (including testing, communicating to users, etc.) has taken well over a week!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload