Contents
A content database in sharepoint is not the database server itself but container for all the content for a single web application. You can have only one content database for one web application however, you can separate content for multiple websites into multiple content databases for a site collection.
Does Office 365 have a database?
Microsoft Access — a part of the Microsoft 365 office suite — offers a robust desktop-class relational database that doesn’t need a server to run. Access databases work from a fixed file on your hard drive or a network share and offers sophisticated tools for creating tables, queries, forms, and reports.
In SharePoint in Microsoft 365, you can create Business Connectivity Services (BCS) connections to data sources, such as SQL Azure databases or Windows Communication Foundation (WCF) web services, that are outside the SharePoint site. See also Deploy a Business Connectivity Services hybrid solution in SharePoint.
How to get the size of a content database?
The first script will provide all the content databases created/associated with the application server in Size of the DB in GB and the content Databases name in a tabular format. The second script will provide all the content database sizes along with the total space required on the new SQL Server to be migrated on.
How do I create a new content database?
On the Manage Content Databases page, click Add a content database. Specify a web application for the new database. Specify a database server to host the new database. Specify the authentication method that the new database will use and supply an account name and password, if they are necessary.
How to move content databases in SQL Server?
In SQL Server Management Studio, open the source SQL Server instance, and then expand the Databases node. Right-click the content database, point to Tasks, and then click Detach. Repeat this step for each content database that you want to move. Use this procedure to move only content databases. Do not detach any other kinds of databases.
In Central Administration, in the Application Management section, click Manage Content databases. On the Manage Content Databases page, click Add a content database. On the Add Content Database page, verify that the Web Application menu displays the correct web application. In the Server box, specify the database server that hosts the database.