Create Site collection with New Content database in SharePoint

In many scenarios you will be required to create a site collection with new Database to satisfy database growth/flexible site collection, which can later move to different web application.

Let’s see step by step how to create a SharePoint site collection with a separate content database using Powershell for SharePoint.

Step:1

Create a managed path under web application : 
Go To Central Admin >> Application Management >> Create Site Collection

Select Defined managed Paths

Enter Site collection name and Type "Explicit Inclusion"

Click on "Add Path".

Step:2

Now we need to create Content Database to host the site collection. Remember we only have Defined managed path and not created Site Collection Yet.

Run below command under Powershell window:

New-SPContentDatabase -Name "WSS_Content_test" -DatabaseServer "Servername"  -WebApplication "http://xyz:6001/test"

$ContentDatabase = Get-SPContentDatabase "WSS_Content_test"

Above command will create Content Database on SQL server.

Step:3

In Final step we need to create site collection with new content database we just created.

Define all parameters:

$url = "http://xyz:6001/test"
$ContentDatabase = "WSS_Content_test"
$WebsiteName = "Test"
$WebsiteDesc = "Site test portal"
$Template = "STS#1"
$PrimaryLogin = "domain\adminuser"
$PrimaryDisplay = "Admin"
$PrimaryEmail = "xyz@domain.com"

Execute the command:


New-SPSite -Url $url –ContentDatabase $ContentDatabase -Name $WebsiteName –Description $WebsiteDesc  -Template $Template -OwnerAlias $PrimaryLogin –OwnerEmail $PrimaryEmail

Site template we selected STS#1 is for blank website. Incase you need to explore more template types, please refer this wonderful article.

Taaada!! Site collection is created with new content database in just three steps.

Tip - In SharePoint 2013 Change the "SharePoint" text in Suitbar - SharePoint Branding

If your goal is simply to change the text, or hardcode a link without the need for any code behind, you could do it even easier with PowerShell.

Changing the SharePoint text to something else using PowerShell

Before:

After:

Power Shell Script:

$webApp = Get-SPWebApplication http://urlofsite:2016

$webApp.SuiteBarBrandingElementHtml = "Text Goes Here" 

$webApp.Update()

$w

Thanks we will share some more findings and articles on SharePoint 2013 branding. till then cheers.

SharePoint 2013: Comparision between Apps and Solutions (.wsp)

Apps in Sharepoint:

Apps are stand-alone applications that provide specific information or functionality to a SharePoint site. Apps for SharePoint are easy for users to install, use, manage, upgrade, and remove. Apps can be SharePoint-hosted (reside and execute in SharePoint) or cloud-hosted (Windows Azure or other systems), or both.




Contents

How to get
 
Apps can be downloaded from:

• Internal App Catalog (contains apps approved and uploaded by the organization)
• Public SharePoint Store

 How to Use / Install

Apps can be used:

• In your hosted or on-premises SharePoint site

 App code is installed:

• On a separate web site from your other sites in its own, isolated, domain·
• In the cloud (cloud-based apps)

How to Manage

Apps can be managed and monitored by:

• Site administrators.
• SharePoint Online Service administrators for a tenancy· 
• Farm administrators

  ============================================================

Solutions in Sharepoint:

Are small to large scale packages used to customize or enhance SharePoint sites. Full trust solutions need a farm or SharePoint Online Service administrator to deploy, manage, and remove. Partial trust solutions must be installed to a sandbox. 

Contents

How to get

Solutions can be acquired from:

• Third-party developers· Your own development team 

 How to Use / Install

Solutions can be used:

• In your hosted (sandbox solutions only) or on-premises SharePoint site

Solution code is installed:

• As a full trust solution (in the global assembly cache).
• As a sandboxed solution 

How to Manage

 Solutions can be installed and monitored by:

• SharePoint Online Service administrators for a tenancy (sandbox)· 
• Farm administrators (sandbox or full trust)