none
Moving Moss 2010 and PWA 2010 DB's to named instance RRS feed

  • Question

  • Hi, We are just about to go live on a PWA implementation at a client and they now tell us that SQL must be under a named instance with a certain name.

    Have to fix this asap so posting this before i have done any research.

    What i think the steps will be:

    1. Snapshots of servers
    2. Backup SQL DB’s
    3. Install New SQL Instance
    4. Uninstall MOSS and PWA
    5. Reinstall Moss with new SQL Instance
    6. Reinstall PWA with new SQL Instance
    7. Restore PWA DB’s over newly created db’s

     

    Would that be the right steps?

    Monday, March 28, 2011 11:20 AM

Answers

  • ...or you could create a new Project Server instance with the new SQL named
    instance, then apply Playbooks to apply your settings.  That may be cleaner.
     Why do you wish to move all of your databases for an environment that hasn't
    gone live?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, March 28, 2011 11:58 AM
    Moderator

All replies

  • ...or you could create a new Project Server instance with the new SQL named
    instance, then apply Playbooks to apply your settings.  That may be cleaner.
     Why do you wish to move all of your databases for an environment that hasn't
    gone live?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, March 28, 2011 11:58 AM
    Moderator
  • Hi, 

    There has been lost of work on PWA that has been done to be ready when we go live so cant start it from scratch...

    The old SQL instance is going to have to be uninstalled so Moss also needs to be recreated.

    Playbooks... what is that?

    Monday, March 28, 2011 12:10 PM
  • Playbooks is part of the Project Resource Kit - which is available for free
    download.  It exports all of your settings and then reimports them to a new
    target instance.
     
    See Alex Burton's post about moving demand management assets for the demand
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, March 28, 2011 12:45 PM
    Moderator
  • Wow, just installed and looking at it.

    Looks very handy and easy to use...

    Cant beliew this is the first time i hear about this tool...

    Thanks, Will first try this solution...

    So with this my steps:Just the last one diffrent...?

     

    1. Snapshots of servers
    2. Backup SQL DB’s
    3. Install New SQL Instance
    4. Uninstall MOSS and PWA
    5. Reinstall Moss with new SQL Instance
    6. Reinstall PWA with new SQL Instance
    7. Restore PWA via Playbooks...

     

    Ok, looks like playbooks dont backup projects... but all settings... will have to check if there was preojects created.

    Thanks

    Monday, March 28, 2011 1:08 PM
  • Well, let's back up a bit.  How much content do you want to keep from the
    current farm?  Do you have projects?  Project sites?  Reports?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, March 28, 2011 1:42 PM
    Moderator
  • Well there is mosly settings but im scared that there is stuf that we might miss...

    Think im going to go with restoring the db first.

    To be honest we are 3 people working on the project and not sure of the other people might have done something. 

    The projects that is in there is just test data...

    There is custom reports...

    Monday, March 28, 2011 1:46 PM