• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

SharePoint 2010 database install

I am installing SharePoint 2010 and my first big choice is: single server or farm.  Even though I only have one server for this I pick farm because it will allow me to use my SQL server.

Next big question:  where is the database?  I haven't created one yet and I can't get past this.  Any suggestions besides go home?
0
GoodDirector
Asked:
GoodDirector
  • 2
  • 2
1 Solution
 
sabby447Commented:
When you pickup the server during install (SQL Server) , It creates a sharepoint_config database in that, With 2010 some more neat databases :), For rest of items you can create those as you start services and run through configuring your farm wizard after install.

here is a broad level step by step : http://www.codeproject.com/KB/sharepoint/SharePoint_Server_2010.aspx
0
 
GoodDirectorNetwork & Systems AdministratorAuthor Commented:
SABBY447,
This is helpful.  Can you provide more light on the single vs farm setup?  I know the difference between the two.  I would liek to pick farm so I can use my SQL server but maybe I don't need SQL or a farm.
0
 
sabby447Commented:
Single with 2010 uses sql express, Its one click install however the problem is that you cannot add more servers in that configuration. This is ideal for a small organization with limited use of data, The limit with sql express is 10 GB max, So if you are planning a small document sharing, content management with basics then it is fine for upto 200 users (It can hold more however 200 is a good number with complexity defined)

For farm: You can start with 1 server and always move to add more servers if needed, This is good if there is any special application and expansion required, You can separate various roles of sharepoint to different servers. The benefit is also you can use SQL server DB thus a central place for all your databases of the organization, This gives you less overhead to manage two db servers and trying to replicate policies to manage the environment

0
 
GoodDirectorNetwork & Systems AdministratorAuthor Commented:
The information about the database was very helpful.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now