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:
- Insert the DPM media on the SQL Server and run the setup. In the setup screen, click on the DPM Remote SQL Prep link:
- The next step is to go through the Microsoft Software License Terms, where you must check the I accept the license terms and conditions checkbox if you agree with the license terms. Click on OK to continue.
- The installation wizard will start and install the DPM Support Files; this is a very quick installation.
- When the installation has finished, a message box appears that informs you that the installation has finished and that the System Center DPM Support Files have been successfully installed:
The support files for SQL Server will be installed on the backend SQL Server box and will be used when the DPM server connects and creates its database.