none
attach databases in powershell vs attach databases in STSADM

    Question

  • i am reading about attaching databases in sharepoint, it says:

    you may have more than one content database per web application, use PowerShell and the Mount-SPContentDatabase command, instead of add existing database using STSADM

    I have searched online, but i can't find any example on how to attach multiple databases in 1 command using powershell. any example?

    vendredi 22 juin 2012 07:28

Réponses

  • Hi,

    Mount-SPContentDatabase – Used to attach a database or multiple parallel databases to the farm.  Essentially is nearly the same as the STSADM –o addcontentdatabase.  It does actually have more options when you start looking at parameters on the surface in each command.  This is where the power of powershell competes on a command level.  If you’re doing parallel content database attach for example, this powershell method is recommended.  You’d simply run each of these in different command/management windows. Please take a look at this article Upgrading to SharePoint 2010 with Powershell


    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

    vendredi 22 juin 2012 11:11

Toutes les réponses

  • Hi,

    If you have multiple content databases that have the same name, you must use the content database GUID in this command instead of using the content database name. To retrieve the GUID of the content database, run the Get-SPContentDatabase cmdlet with no arguments. Take a look at this article Attach or detach content databases (SharePoint Server 2010)


    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

    vendredi 22 juin 2012 09:53
  • Hi Dmitry, I appreciate your reply but that is not my question, my questions is that I read that with attach DB you can upgrade more than 1 database in the same time, using mount-spcontentDB, if you use STSADM you can only attach one at a time, how do i use mount command to attach more than one database (with different names) at the same time. All i can see is that it can update one db at a time.
    vendredi 22 juin 2012 10:43
  • Hi,

    Mount-SPContentDatabase – Used to attach a database or multiple parallel databases to the farm.  Essentially is nearly the same as the STSADM –o addcontentdatabase.  It does actually have more options when you start looking at parameters on the surface in each command.  This is where the power of powershell competes on a command level.  If you’re doing parallel content database attach for example, this powershell method is recommended.  You’d simply run each of these in different command/management windows. Please take a look at this article Upgrading to SharePoint 2010 with Powershell


    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

    vendredi 22 juin 2012 11:11
  • aha, so there is no command for mounting all databases together, I have to open multiple windows together? wouldn't that work with stsadm?
    vendredi 22 juin 2012 13:40
  • No, you can't do it in one command. You should use PowerShell because extending STSADM.EXE has been deprecated and will not be supported in future releases of SharePoint.

    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog


    vendredi 22 juin 2012 13:51
  • if you really need to attach all the databases in one command you can read the entries from a text file and batch it up so that it does it automatically the only issue is if there are any issues you need to wait until all of them finishes or break it and then fix it if you are sure it doesn't have any issues then i would suggest that approach

    it can be done with both commands the adavantage with mount is if you want the users to directly upgrade thier look and feel to sharepoint 2010 then there is a parameter called UpdateUserExperience

    it changes the user interface directly to 2010 it all depends on what you want to do 

    vendredi 22 juin 2012 15:03