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

Answer 1

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

Answer 2

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.

Answer 3

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.

Answer 4

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

Answer 5

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.

Answer 6

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.

Answer 7

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

Answer 8

Good Day

can someone help me please , I will be thankful .

Many Thanks

---

e

Answer 9

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.

Answer 10

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

Answer 11

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.

Answer 12

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

Answer 13

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.

Answer 14

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

Answer 15

Good Day ,

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

Many Thanks

---

e

Answer 16

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.

Answer 17

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

Answer 18

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.

Answer 19

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

Answer 20

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.

Answer 21

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

Answer 22

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.

Answer 23

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

Answer 24

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.

Answer 25

ok , so also for Mount-SPContentDatabase "WSS_Content" -DatabaseServer WKSERVER -WebApplicationhttp://wkserver ?

thanks a lot for your help

regards

---

e

Answer 26

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

Answer 27

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.

Answer 28

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

Answer 29

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.

Answer 30

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

Answer 31

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

Answer 32

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