Install MEMCM (TP) - Database

Installation will be done for the MEMCM TP (Technical Preview)

The Current Branch should install the same

Extend AD Schema for MEMCM

Inside the installer there should be a file called extadsch.exe

MEMCM Installer\SMSSETUP\BIN\X64\extadsch.exe

Run as Account that has rights to extend AD Schema if you do not have that permission

Should be a brief CMD window pop up

To verify you may view the log file on the root of C:\ExtADSch.log

Create System Management CN (Container) in AD

On Domain Controller launch ADSI Edit

Create New Container under CN=System

Name the container

System Management

Change the permissions of the newly created System Management CN

Security Tab then click Advanced

Add the Computer account of the Site Server you just installed MEMCM on

And ensure to set - This Object and all descendant object, and check Full Control

Manually create MEMCM DB, Files and Files sizes

Launch SSMS

Connect to SQL

Create new DB

Name the DB

CM_<3 digit site code you wish to use>

Owner put in sa

Now time to configure our Files and File sizes

Configure roughly 4-8 files

How many files you choose divide the client estimation total by the number of files = Each file size

Select Add to add additional file until you reach the number you decided

Now name each file same as the DB name with _ with consecutive numbers at the end

Change the size so all total equal total client configuration

For the log file roughly do 1/2 of the total size of the MDF files

Increase the autogrowth for the MDF Files to 128

Increase the autogrowth for the Log File to 256

Now change the path to where these files will be stored

copy the path to your MDF drive database folder

Now change the Path of all the MDF files only

For the Log file when have created its own drive also

Now change the Path of the log file

Under Options change recovery model to simple

Now Click OK and it will create the files

You can check files that were created

Last updated

Was this helpful?