How to Manage a SharePoint Content Database

SharePoint content database is the most important part of running a successful SharePoint site and without the best customization, some website pages and posts might end up becoming corrupted or unrepresentable. If you run a SharePoint website or content management software, you must always ensure that it’s content database is well managed to avoid frequent interruptions and hitches. If you are new to SharePoint, you can learn some few tips of how to easily manage your website content database without necessarily seeking help from a professional web programmer.

How to Manage a SharePoint Content Database

How to Add content database to a 2013 SharePoint Web app

  • You can easily add a content database to your site farm by using windows power-shell or the Sharepoint central administration site. The kind of tools that you use mainly depends with your scheduled requirements, service-level agreements and the kind of environment you will deploy. SharePoint allows webmasters to add any new database content or attach new contents from a database backup file.
  • Before you add any content database, you must ensure that the user account performing the operation is a member of your site farm administration group in order to avoid errors.
  • Also, if you will use a windows authentication software to connect to the SQL server, verify that the user account is a member of db-creator fixed server on your SQL server.

Adding content database to a web app by using “Central-Administration”

A. The first thing to do is to ensure that your user account that will perform the action is a member of the site farm administration group.

B. If everything is correct, start the central administration in your SharePoint.

-For 2008 windows server R2, click on start, navigate to Microsoft 2013 products and finally click on 2013 sharepoint central administration.

-If you are using 2012 windows server click on the “2013 sharepoint central administration” on the server’s start screen.

C. Click on “application-management” on your sharepoint central adim website.

D. Navigate to the database section and click on “Manage-Content-Database”

E. At the “Manage-Content-Database” page click on “Add-A-Content-Database”

F. on “Add-A-Content-Database” page;

  • Specify the web app for the new content database
  • Specify the appropriate database server of hosting the new content database
  • Specify a suitable authentication method of your own choice for the new content database. You can use your account name or simply set a new password if it’s easy for you to remember.
  • After that, specify a name for he fail-over-database server if it exists.
  • Specify the numbers of top level websites that can be generated before a warning message is issued. By default SharePoint allows up to 2,000 of them.

G. After you are done done click on “OK” to finish and exit.

Adding content database to -a web app using “Windows-Powershell”

a. The first thing to do is to ensure that you have the following membership’s

  •  A security admin fixed server
  • A db-owner fixed database
  • An administrator group on which you will run the windows powershell cmdlets.

b. after verifying everything click on “All-Programs” on the start-menu.

c. Click on “Microsoft-SharePoint-2013-Products”

d. click “Microsoft- SharePoint-2013- management Shell”

e. At the command prompt of the “Windows-PowerShell” type this command:- “New -(your sharepoint content database) -Name (content Db-Name) -webapp (the web application name)

– (the web application name) – is the name of app to which new content database is attached

How to Attach and Detach Content Database

Detaching and attaching content database helps you to add new content data-base for new websites collections and keep them in a manageable file size and also restore database content from a separate farm of your site. Despite this, you can easily detach the content data-base from a web app after archiving the site collections out of the content content data-base.

To detach or attach content database using “windows-powerShell” do the following:

a. First verify that you have the following memberships

  • A security admin fixed server
  • A db-owner fixed database
  • An administrator group on which you will run the windows poweshell cmdlets. If you are the administrator of your site, you can grant new permissions for using cmdlets.

b. Click on “Microsoft-SharePoint-2013-Products”

c. click “Microsoft- SharePoint-2013- management Shell”

d. when promoted to the command prompt, type your codes respectively.

How to move all SharePoint Database to a new data-base serve
For different reasons, you might want to migrate your old site database to a new server in order to enhance good user interface with your site members and users. If you have a server that frequently experiences down-times, you need to upgrade to a new server that functions with the least interferences as possible.

There are many instances when a SQL server experience technical hitches and deliberately stops working. To avoid interferences, you can move your sharepoint database to a new server and let your users enjoy the best browsing technology ever. Most SharePoint content database can thousands of files depending on the site complexity, to avoid frequent loss of data, a sharepoint admin should back up all sites database to a cloud storage that is safe.

To move SharePoint content database to a new server, you need the following permissions:

  • To move a content database, you must ensure that the user account performing the operation is a member of your site farm administration group in order to avoid errors.
  • On the data-base server where files are being moved, you must be a member of the administration group and the db-backup operator.
  • On the new data-base server that will receive the database, you must also be a member of the administration group and have a fixed role on the data-base.

Steps on how to move content database from SharePoint to a SQL server.

1. First you new to test the new SQL server and ensure it’s working properly.

2. Close all sharepoint shell windows.

3.Stop the (IIS) internet information service and all other services that are related to the SharePoint site.

4. Detach all the data-base from your current SQL server.

5. Copy all files such as .ndf, mdf and .ldf to the new destination folder of your new SQL server than you want to run.

6.Test the server login’s and fix any problems that arise with your new content server. If everything is well configured close the server window and log in to your SharePoint site using your username and password.
By performing the following procedures, you can easily solve any technical hitches experienced with your content database server and restore normal browsing on your site. SharePoint content database management system is very easy to customize and it allows users to perform different functions that control how data is displayed.

sharepoint banner

Marissa Hart is the Lead Author & Editor ShareMe. ShareMe is a blog focused on SharePoint Online. SharePoint Online delivers the powerful features of SharePoint without the associated overhead of managing the infrastructure.