Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SharePoint 2010 database install

Posted on 2011-03-08
4
Medium Priority
?
304 Views
Last Modified: 2012-08-13
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
Comment
Question by:GoodDirector
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:sabby447
ID: 35071548
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
 

Author Comment

by:GoodDirector
ID: 35071997
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
 
LVL 6

Accepted Solution

by:
sabby447 earned 500 total points
ID: 35072041
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
 

Author Closing Comment

by:GoodDirector
ID: 35072517
The information about the database was very helpful.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question