Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

September, 2008

  • Brian Smith's Microsoft Project Support Blog

    RSS Readers will now get my full postings again!

    • 2 Comments

    Back in June I flicked a switch on my blog that meant that after about 4 lines you would get a “read more” link and if I had grabbed your attention you might even click and read the rest. Today I have flicked the switch back again after feedback that people prefer to get the full post rather than having to go look for the rest of it.

    The reason I had set it this way was that it did at least give me some indication of what was being read – because I could see the visits to the pages.  The RSS hits don’t really give me that information.  However, I appreciate that many readers may consume these posts offline – or even if you are online it is extra clicks and time to get the full story.  In return for my setting this back to the way you want it I ask that if you like or don’t like a posting – let me know!

    The stats I get from adCenter break down into 3 groups in terms of inbound referrals to the pages – search, direct traffic and referring websites.  For September so far I am running at just over 61% search, around 24% for direct traffic, and the final 15% from referring websites.  I am guessing that much of the direct traffic is from RSS readers hitting the “read more” link – and probably a few that have links saved – it will be interesting to see how the figures change over the coming weeks and months as the changed setting comes into play.

    Do let me know how you feel about this change.

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2007: August Cumulative Update – KB Articles are now posted!

    • 1 Comments

    Christophe has a great blog with full details of the KB’s for WSS (KB956057) MOSS (KB956056) and Project Server (KB956061) which are now available.  Everything you need to know about the August Cumulative Update is there – links to articles, links to the hotfixes and some guidance on installation!

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2007: Moving a copy of Production to Test – Part 2

    • 25 Comments

    I will be going deeper in this posting, particularly on the scenario of moving just the databases and then re-provisioning the site.  But don’t expect me to be mentioning every single dialog box and permission that you require.  I will be writing at a level whereby if you don’t understand what I am saying then perhaps you shouldn’t be doing this – or at least you need to read around a bit and then come back.  For permissions see this blog posting, and for full details of full farm restore go here.  Remember that any additional Process Accounts added to the SSP must still exist and be verifiable in the new system.  Forgotten this one?  Then go here.

    So the only extra I intend to say about full farm backup and restore is that it does not keep such things as LDAP forms based authentication extended sites and settings (Thanks Boris Bazant for this tip!).  As I mentioned in my part 1 post – some external customization will need to be re-applied (e.g. additional web parts, server side event handlers in the GC).

    The scenario for the main part of the post is moving from my Production Server (BriSmith620) to my test system (A Hyper-V image called BriSmithV0832).  I already have a working site which I don’t want to break, so this is a partial move – and the projects in my Production Server have workspaces both in the root site under PWA (the instance I am interested in is actually called CAL – created to troubleshoot some Calendar issues)  and in another web application at Port 94.  So I will be moving over 4 project databases and 2 content databases.  I can’t move my port 80 to port 80 as it will break existing stuff – so I will move 94 to 94 and 80 to 8080.  I have Issues lists with items in several projects – the aim will be to see these still working post migration…

    I’ve already backed up my 6 databases – and restored them with names Blog_Archive etc for the Project ones and Blog_80_Content and Blog_94_Content (actually on the same server with different names) so on with the restoration of my PWA site and content.  First I just provision a site against the 4 databases.  If you have restored the content db at this point it will fail – if you use the same name for the site – as a collection will already exist.  And if you delete the site away goes your content – Catch 22.  So we are leaving the content stuff for now…

    Usual stuff is entered for creation of a site

    image

    Click OK and wait for it to be provisioned…

    image

    And here we have it!  (Must get round to those timesheets)  Any customizations we had made in SharePoint would be gone (themes, top links etc.) but customizations in PWA would be retained (Notice the My Timecard edit to the menu name in the left nav bar).  But of course none of the workspaces are found, and the issues and risks link also find no active issues for me.

    Next I will add the port 94 content db to a new Web Application on Port 94.  I create a new Web Application and name the database the one I have restored.  Didn’t bother with a screen shot, just changed the port to 94, put in a suitable account for the new application pool and put in the Blog_94_Content database name.  Once this is active I can browse to the workspaces (assuming I know the names) and the issue is there – but clicking through to the issue detail gives a File Not Found SharePoint error.

    image

    The workspaces listed on the home page don’t link to port 94, but port 80, and the Project Workspaces page shows blank for the sites.  By going to the Edit Site Address option the site can be entered for the project.

    image

    Once this is set and the workspace provisioning setting matched to the port 94 address that was in use on the other server the home page then shows the correct links and sees that I have active issues.

    image

    If I follow the link to the workspace, then the issues and click through to the issue detail it works – the file not found is resolved!

    image

    For larger jobs than this simple set of Projects the RelinkAllWSSSite tool from the Project Resource Kit comes in very handy.  Now we have our port 94 sites all sorted – and we could just do the same for our ones that were on port 80 – and leave them on port 8080 – but that doesn’t get them back were they started.  Stsadm export and import comes to our rescue.  First I will add a new web application on port 8080 and use the port 80 content database from the original server.  At this point we can browse to the sites just substituting http://brismithV0832:8080 for http://brismith620 to confirm they are there.  To export and import we use stsadm –o export –url <full url> –filename <path to save site> –includeusersecurity –nofilecompression.  In this case

    C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\BIN>stsadm -o export -url "http://brismithv0832:8080/CAL/Project1 with Workspace in PWA" -filename "C\backup\savesite.bak" –includeusersecurity –nofilecompression

    ***UPDATE*** Flag –includeusersecurity was not in the original posting.  This ensures the same security applies to the site and this then means any assigned issues, risks will be flagged on the users home page.

    If on Windows Server 2008 then your command prompt will need to be running as administrator to avoid an Access Denied.

    You will get a long listing of progress (or you can use the –quiet flag) and hopefully it should finish with success!

    Now we can import, just using the default port 80 address to get our site where we want it (just change the URL and export to import.  In my case I can also change CAL to Blog in the URL as my PWA site has changed.  Once this is complete we have the site where we want it – we edit the site address as we did earlier and all should be working!

    image

    image

    Along the way with the export/import we lost the task links – I will dig into this a bit more but I guess you might expect this as the export probably has nowhere to keep that information, and also I see my Active Issues count isn’t picking up the moved workspace issues.  The best approach is certainly keep the workspaces away from your PWA site to start with.  But the issue is still there – it still understand which project it belongs to.

    image

    I’ve stepped through with a single project so you understand the idea – you can speed things up with Powershell or just creating a batch file.  If you go this route then stsadm –o enumsubwebs –url <url where sites are> >> c:\sitelist.txt will enable you to get a quick list of sites into a text file.

    Every requirement will be slightly different – full farm backup/restore will hopefully work for most, but the details I’ve given here should help when you want perhaps a partial move of single instances.  Always consider customization too – usually you will need some manual steps for those.

    Let me know how this works for you.

    Technorati Tags:
  • Brian Smith's Microsoft Project Support Blog

    Announcing the Microsoft Project Server 2007 IT Professionals TechNet webcast series

    • 0 Comments

    Time for me to steal back from Christophe – see his blog posting at http://blogs.msdn.com/chrisfie/archive/2008/09/24/announcing-the-microsoft-project-server-2007-it-professionals-technet-webcast-series.aspx.

    Brief introduction here – full story, details and dates on Christophe’s blog

    Starting October 1st, 2008, Michael Jordan (Lead Architect – MCS EPM Global Practice | WW COE for EPM) will present a series of Project Server 2007 webcast on TechNet targeted at IT Professionals

    These 60 minutes webcasts will present in details key aspects to consider when you evaluate, plan, deploy, and operate Project Server 2007.

    Technorati Tags:
  • Brian Smith's Microsoft Project Support Blog

    Video blogs on Task Statusing on http://blogs.msdn.com/project

    • 0 Comments

    Treb and Dave are working on a series of Silverlight video blogs around task statusing and timetracking – and specifically what the administrative options do, and the first is live at http://blogs.msdn.com/project/archive/2008/09/23/video-review-of-project-2007-task-settings-and-display-administrative-options.aspx and as you can guess from the URL it covers task settings and display settings in the Server Settings page.

    Enjoy!

    Technorati Tags:
Page 1 of 2 (10 items) 12