Salaudeen Rajack's SharePoint Experiences!
By default, the maximum number of site collections in a SharePoint 2013 content database is set to 5000, and the warning level will be 2000 as initial configurations. Although technically SharePoint 2013 content database can hold up to 10,000 site collections maximum (2,500 non-Personal site collections and 7,500 Personal Sites, or 10,000…
Read more
Although a content database can accommodate up to 10,000 site collections in SharePoint, it’s not advisable to use it so, as the recommended size of the content database is < 200 GB in SharePoint 2013. Also, that could introduce Security, Backup-restore issues to affect your SLA. When you create a new site…
Read more
During audit/migrations, we had a requirement to generate reports on SharePoint content databases and list of sites collections lives in each content database. PowerShell script to Get all content databases and their Site collections: The One liner for the above script would be: This PowerShell script outputs all SharePoint content databases with…
Read more
Requirement: Create a site collection in new database Having a dedicated content database for each site collection is recommended for larger SharePoint site collections. Create a site collection in a new content database in SharePoint using PowerShell: As the Central Administration doesn’t provide any direct interface, let’s use PowerShell cmdlet to create…
Read more
Introduction SharePoint stores most of the data in SQL Server. Stress on SQL servers causes stress on front-end servers, which ultimately degrades the user experience. Healthy SQL Server = Healthy SharePoint! So here are the best practices for SQL Server with SharePoint 2010. Whether SQL Server 2005 or SQL Server 2008 or…
Read more
My requirement is to rename a site URL, so I took a STSADM backup, then I went to restore using the new URL. When I ran the restore with the new URL, It resulted in the below error: “No content databases are available for this operation. Create a content database, and then…
Read more