This recipe will cover the installation process in two scenarios:
- Local SQL Server instance
- Remote SQL Server instance
This recipe will cover the installation process in two scenarios:
SQL Server is a core component and is required for the System Center Data Protection Manager database. It is of major importance that the installation and design of SQL Server is well-planned and implemented. If you have an undersized installation of SQL Server, it will provide you with a negative experience while operating the System Center Data Protection Manager.
The following requirements are recommended for a SQL Server database:
The following steps will cover the installation process of a local SQL Server that has been collocated with the DPM server on the same operating system.
Make sure that your operating system is fully patched and that is has been rebooted before you start the installation of SQL Server 2016. Now, follow these steps:
When you need to build a large hosted DPM solution within your modern datacenter, you may want to use a dedicated backend SQL Server that is either a standalone SQL Server or a clustered one, for high availability. This step will cover the procedure to prepare a remote SQL server for hosting the DPM database.
After installing your backend SQL Server, you must prepare it for hosting the DPM database. Now look at the following steps:
SQL Server is a very important component for System Center Data Protection Manager. If the SQL Server is undersized or misconfigured in any way, it will reflect negatively on the performance of DPM.
It is crucial to plan, design, and measure the performance of SQL Server before you install the DPM server so that you know it will fit the scale you are planning for and the workloads that it should host.