Solved

SharePoint 2010 database install

Posted on 2011-03-08
4
297 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 125 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
My Sharepoint challenge 4 45
Sharepoint to FTP? 3 67
SSRS Total a column based on a calulated field - Report Writer 3.0 12 67
SharePoint List Calculated Field 4 34
Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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