none
Best Practices for SharePoint Server standart2010

    Question

  • Good Day ,

    I hope if someone can help me , I need to migrate sharepoint Fondation 2010 to sharepoint server standart 2010 .

    my question I must separate the sql server from sharepoint, so I create one server sql and another sharepoint standart 2010 ?

    and after i migrate ?

    thanks in advance

    e

    Wednesday, April 04, 2012 1:08 PM

Answers

  • install SQL to one VM, then install sharepoint to second VM using server farm/complete option.

    Run sharepoint config wizard - enter sql server name, enter farm account and your farm will be configured.

    List of needed accounts http://technet.microsoft.com/en-us/library/ee662513.aspx


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Tuesday, April 17, 2012 12:12 PM
  • You have 2 choices, you can either use in-place upgrade or use database attach upgrade for your Foundation

    http://technet.microsoft.com/en-us/library/cc262342.aspx

    You might separate SQL and SharePoint to two servers, and perform farm installation. If you will perform a clean installation, you should backup the content databases on your foundation and restore them to the SharePoint standard.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Wednesday, April 04, 2012 1:27 PM
  • You could do the inplace upgrade as suggested by Marek if you intend to remain with 1 server for your SharePoint environment. 

    Before you do anything, as usual backup everything, if you're in a position too you could take a snapshot as your using VMware.  Depending on resources and which environment this is in, you could do the inplace and then look to seperating out the DB's later.


    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, April 04, 2012 2:14 PM
  • Create a new server - install as a farm.
    Configure the service applications.
    Backup your content databases from the old sql server, copy them to your new SQL server, restore to the new SQL server.
    Create web applications using existing database names, attach remaining content databases.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, April 12, 2012 9:06 AM
  • If you can create a clean virtual machine for your sharepoint and for your sql, if you cannot, you can use existing sql server but you have to be carefull about naming your config db and service application databases, as you already have some on your sql now.

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, April 12, 2012 9:49 AM

All replies

  • Good Day ,

    I hope if someone can help me , I need to migrate sharepoint Fondation 2010 to sharepoint server standart 2010 .

    my question I must separate the sql server from sharepoint, so I create one server sql and another sharepoint standart 2010 ?

    and after i migrate ?

    thanks in advance


    e

    Wednesday, April 04, 2012 12:42 PM
  • Hi Zikorai,

    Post your question in the 2010 forum and you'll get responses. http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010setup/threads


    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, April 04, 2012 12:52 PM
  • You have 2 choices, you can either use in-place upgrade or use database attach upgrade for your Foundation

    http://technet.microsoft.com/en-us/library/cc262342.aspx

    You might separate SQL and SharePoint to two servers, and perform farm installation. If you will perform a clean installation, you should backup the content databases on your foundation and restore them to the SharePoint standard.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Wednesday, April 04, 2012 1:27 PM
  • Thanks for you answer , I have one server include sqlserver2008R2 64bit and sharepoint Fondation 2010 in Vmware is virtual machine

    I need your advice about the steps that i will do:

    1-I creat one new  virtual machine that i install sharepoint server standart 2010

    2- the second server i will remove sharepoint Fondation 2010 and I leave just sqlserver 2008R2 64bit

    3-I will migrate by command line from sharepoint Fondation to standart

    Many Thanks


    e

    Wednesday, April 04, 2012 1:58 PM
  • You could do the inplace upgrade as suggested by Marek if you intend to remain with 1 server for your SharePoint environment. 

    Before you do anything, as usual backup everything, if you're in a position too you could take a snapshot as your using VMware.  Depending on resources and which environment this is in, you could do the inplace and then look to seperating out the DB's later.


    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Wednesday, April 04, 2012 2:14 PM
  • Hi

    I suggest install separate SharePoint2010 and SQL , You have install in new farm and use database attach and detach to new farm. I suggest this way.

    Wednesday, April 04, 2012 3:02 PM
  • Good Day ,

    Thanks

    I create new server that i will install now sharepoint server like server Farm ?

    and when i finich the instalation i can attache the database that i have in the old server that include database and sharepoint fondation  and afther I reinstall the sharepoint Fondation ??

    Thank you


    e

    Wednesday, April 11, 2012 5:03 PM
  • Good Day

    can someone help me please , I will be thankful .

    Many Thanks


    e

    Thursday, April 12, 2012 8:54 AM
  • Create a new server - install as a farm.
    Configure the service applications.
    Backup your content databases from the old sql server, copy them to your new SQL server, restore to the new SQL server.
    Create web applications using existing database names, attach remaining content databases.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, April 12, 2012 9:06 AM
  • excuse me , the idea is like that :

    I have one new server sharepoint server standart 2010 i will install it as a farm that is ok

    but the second step I have the old server sharepoint Fondation 2010 taht is include also sqlserver2008 64Bit . my question is it's possible

    after instalation of sharepoint server standart2010 , I can use the same sqlserver that i have in old server and just I reinstall sharepoint Fondation from the old server ???

    and is recomended to have to defferent server , one sharepoint server standart 2010 and the second sql server ?

    Many Thanks


    e


    • Edited by zikorai Thursday, April 12, 2012 9:27 AM
    Thursday, April 12, 2012 9:25 AM
  • I would recommend to separate sharepoint and sql server into two servers. And also to perform a clean install of an SQL server, as I would guess you did install foundation as basic installation with express edition, right?

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, April 12, 2012 9:30 AM
  • the old server this is the configuration:

    windows2008R2 include : Sharepoint Fondation 2010 + Sql Server 2008 R2 64 and I have Three partition: C: include sharepoint and instalation of sql server 2008 R2 , D: Data (mdf file) , E:Log (ldf File) and is a virtual machine .

    Many Thanks


    e

    Thursday, April 12, 2012 9:39 AM
  • If you can create a clean virtual machine for your sharepoint and for your sql, if you cannot, you can use existing sql server but you have to be carefull about naming your config db and service application databases, as you already have some on your sql now.

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Thursday, April 12, 2012 9:49 AM
  • yes now I create new virtual machine for sharepoint server 2010 , and I will stop the old server and I reinstall sharepoint Fondation and I leave just sql server 2008 inside the old one and attache with the new sharepoint server ?

    e

    Thursday, April 12, 2012 9:53 AM
  • Good Day ,

    the procedure that I will follow is correct ? can someone advice me ?

    Many Thanks


    e

    Friday, April 13, 2012 8:56 AM
  • You dont have to reinstall foundation.

    Backup your old content databases from foundation

    Create two new VMs

    Install SQL Server to VM1
    Install SharePoint server to VM2
    Configure your SharePoint server
    Restore backups of your content dbs to your SQL
    Create web application using existing DB name
    If any, attach additional content dbs in central admin

    this might help http://technet.microsoft.com/en-us/library/cc262342.aspx#DBAttach


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Friday, April 13, 2012 9:00 AM
  • thank you for you time ,

    I created two new VMs , now i need to install sql and sharepoint have you a link that he show me how can'i install sql and sharepoint in  defrent server becasue i hve link to install in the same server , I will be thankful.

    Many Thanks


    e

    Tuesday, April 17, 2012 11:47 AM
  • install SQL to one VM, then install sharepoint to second VM using server farm/complete option.

    Run sharepoint config wizard - enter sql server name, enter farm account and your farm will be configured.

    List of needed accounts http://technet.microsoft.com/en-us/library/ee662513.aspx


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Tuesday, April 17, 2012 12:12 PM
  • Good Day ,

    sorry I answered late because i was working in another problem , thanks for your help .

    I followed your instruction , now I have SQL VM and Sharepoint VM . My question is now I attache just the database that I have in sharepoint Fondation server in the SQL vm and will work ?

    Sorry for the disturbing and thanks in advance .


    e

    Tuesday, April 24, 2012 9:28 AM
  • You have to restore your databases in sql vm, and then you have to recreate sharepoint web application in your sharepoint vm and use existing name for your dbs. And also if you have multiple content databases you have to attach them in central administration.

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Tuesday, April 24, 2012 9:33 AM
  • how i can recreate sharepoint web application ?

    I attach the database , but how can I have the same congiguration sharepoint Fondation in sharepoint server standard ?

    I m worry because  I have a lot of data .

    Many thanks


    e

    Tuesday, April 24, 2012 10:01 AM
  • Did you consider to hire some professional to do this for you?

    Anyway .. in central administration you have to at first create service applications - configure your sharepoint enviroment. Afterwards you can create a web application in central administration. You need to enter hostname for your web app, db server name and db name and few more information. When the web application will be created with a db name of an existing content database you should see in your site collection list your existing site collections.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Tuesday, April 24, 2012 10:10 AM
  • excuse me when I attach the database i do this commande line :

    Mount-SPContentDatabase "WSS_Content" -DatabaseServer WKSERVER -WebApplication http://wkserver

    After I do this commande line:

    $webapp = Get-SPWebApplication http://wkfserver
    foreach ($s in $webapp.sites)
    {$s.VisualUpgradeWebs() }

    Is correct ?

    Many Thanks


    e

    Wednesday, April 25, 2012 10:09 AM
  • there is no need to use visualupgrade since you have attached the database from 2010 version already

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Wednesday, April 25, 2012 10:11 AM
  • ok , so also for Mount-SPContentDatabase "WSS_Content" -DatabaseServer WKSERVER -WebApplicationhttp://wkserver ?

    thanks a lot for your help

    regards


    e

    Wednesday, April 25, 2012 11:18 AM
  • Dear Marek Chmel ,

    I attached the database , now i will use this command:

    Mount-SPContentDatabase "WSS_Content" -DatabaseServer WKSERVER -WebApplicationhttp://wkserver ?

    or I go to the Central Administration and I did configuration manulay ?

    this is the last step if you can help me I will be very kind from your side and excuse me for the disturbing

    Regards


    e

    Friday, June 01, 2012 3:41 PM
  • You can choose if you would like to use PowerShell or Central Admin, your command is valid and can be used for attaching.

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Friday, June 01, 2012 3:48 PM
  • Thanks Marek Chmel ,

    I opened the powerShell in VM SQL and I put the line commande Mount-SPContentDatabase "WSS_Content" -DatabaseServer SQLSERVSHARP -WebApplication http://SQLSERVSHARP

    but give me this message error :

    The term 'Mount-SPContentDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:1 char:24+ Mount-SPContentDatabase <<<<  "WSS_Content" -DatabaseServer SQLSERVSHARP -WebApplication http://SQLSERVSHARP    + CategoryInfo          : ObjectNotFound: (Mount-SPContentDatabase:String) [], CommandNotFoundException
        + FullyQualifiedErrorId : CommandNotFoundException

    many thanks

    e

    Tuesday, June 05, 2012 8:27 AM
  • You have to use SharePoint Management Shell (in the start menu/SharePoint 2010) not just basic PowerShell.

    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Tuesday, June 05, 2012 9:38 AM
  • Excuse me  I went to Sharepoint VM : and I opened Sharepoint Management Shell :

     

    PS
    C:\Users\Administrateur> Mount-SPContentDatabase "WSS_Content" -DatabaseServer SQLSERVSHARP -WebApplication http://SQLSERVSHARP 
    Mount-SPContentDatabase: Cannot find an SPWebApplication object with Name, Id, or Url: http://SQLSERVSHARP.
    At line:1
    char:24
    +
    Mount-SPContentDatabase <<<<  "WSS_Content"
    -DatabaseServer SQLSERVSHARP -Web
    
    Application
    http://SQLSERVSHARP
    
       
    + CategoryInfo          :
    InvalidData: (Microsoft.Share...ContentDatabase:
    
      
    SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPCmdletPipeBindE
    
     
    xception
    
       
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMountCon
    
      
    tentDatabase

    excuse me but realy strange I did the same steps when I migrate from wss3.0 to Fondation 2010 , the deferens now I have sql and sharepoint in deferens server .

    Many Thnaks

     


    e


    • Edited by zikorai Tuesday, June 05, 2012 10:17 AM
    Tuesday, June 05, 2012 10:15 AM
  • Can you please help me ?

    Mount-SPContentDatabase "WSS_Content" -DatabaseServer SQLSERVSHARP -WebApplication http://SQLSERVSHARP

    $webapp = Get-SPWebApplication http://SHAREPOINTSERV
    foreach ($s in $webapp.sites)
    {$s.VisualUpgradeWebs() }
    

    this is correct ? give me error about the VisualUpgradeWebs

    PS
    C:\Users\Administrateur> $webapp = Get-SPWebApplication http://SHAREPOINTSERV 
    
    PS
    C:\Users\Administrateur> foreach ($s in $webapp.sites) {
    $s.VisualUpgradeWebs() }
    
    Exception
    calling "VisualUpgradeWebs" with "0" argument(s):
    "<nativehr>0x800700
    
    03</nativehr><nativestack></nativestack>"
    
    At line:1
    char:53
    
    + foreach
    ($s in $webapp.sites) { $s.VisualUpgradeWebs <<<< () }
    
       
    + CategoryInfo          :
    NotSpecified: (:) [], MethodInvocationException
    
        + FullyQualifiedErrorId :
    DotNetMethodException

    Many thanks


    e



    • Edited by zikorai Wednesday, June 06, 2012 11:21 AM
    Wednesday, June 06, 2012 9:31 AM
  • when I execute the command line :

    $webapp = Get-SPWebApplication http://SHAREPOINTSERV
    foreach ($s in $webapp.sites)
    {$s.VisualUpgradeWebs() }

    give me error can someone help me please ???????


    e

    this commande I use it to migrate from wss3.0 to sharepoint Fondation 2010 , is useful also to migrate from sharepoint Fondation 2010 to sharepoint server standart ???

    Many thanks

    • Edited by zikorai Thursday, June 07, 2012 8:50 AM
    Thursday, June 07, 2012 8:31 AM