Solved

SharePoint 2010 database install

Posted on 2011-03-08
4
296 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
Comment Utility
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
Comment Utility
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 125 total points
Comment Utility
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
Comment Utility
The information about the database was very helpful.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now