Solved

SharePoint 2010 database install

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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