Database maintenance plans are gone from Database Manager in NPM 10.4.2

PHA

I recently upgraded to NPM 10.4.2 from 10.4. Now I am receiving notifications that "SAM Database Maintenance Is Overdue". The "Help Me Fix This" link says to:

Creating a Database Maintenance Plan

Using Database Manager, you can create a database maintenance plan that will automatically compact and backup the database on a scheduled basis. As a security and information integrity issue, it is very important to regularly back-up your databases. Database Manager allows you to do this easily, using the following steps.

Note: SQL Server Agent must be running to execute database maintenance.

To create a database maintenance plan:

1. Click Start > All Programs > SolarWinds > Advanced Features > Database Manager.

2. If the SQL Server hosting your SolarWinds database is not listed in the left pane, you must add the SQL Server hosting your SolarWinds database. For more information, see “Adding a Server”.

3. Click [+] in the left pane to expand the SQL Server hosting your SolarWinds database, and then click your SolarWinds database.

Note: SolarWinds Orion is the default name of the SolarWinds database.

4. Click Database > Database Backup Schedule.

However, I have no such "Database" option in Database Manager. All I have is "Add a server" (which I have done). I set up the backup using the standard SQL methods (using their maintenance plan to make a backup), and that is working; I see the BAK file created when I scheduled it.  But how can I do the rest of the maintenance - compacting, removing data older than data retention policies allow, etc?

Seems like the documentation isn't matching the latest version of Database Manager.

PHA

Here is what Tech Support had me do (as manual maintenance):

You will need to do the following.

Database Essential Maintenance

*** IMPORTANT NOTE ***

Please make sure to have a recent backup of your database as the following instructions will make permanent changes to your database

Before doing anything please open Orion Service Manager and stop all services.

- Open SQL server Management Studio.

-(If you don't have a copy of this, you can download and install SQL Server Management Studio Express from Microsoft for free)

- Connect to your SQL server

To Shrink your Transaction Log File (.ldf)

- Right click the Orion database and choose All Tasks -> Shrink -> File

- Ensure the File Type is set to Log, file group will not be an available option.

- Please note, shrinking the log file will not be useful if the database is set to "Full Recovery" mode. This mode causes every transaction to be stored in the transaction log file, to allow the DB to recover to the last transaction if required. In comparison, Simple recovery will only allow recovery to the last good backup.

- For the Shrink Action, select "Reorganise pages before releasing unused space. Change the "Shrink File to" setting to 0 MB.

- Click OK. This will take a few seconds.

How to Shrink the Main Database (.mdf)

- Right click the Orion database and choose All Tasks -> Shrink -> Database

- For the Shrink Action, select "Reorganise pages before releasing unused space.

- Change the Maximum Free Space in files after shrinking = 0

- Click OK. This can take a while - usually a few mins per GB

To shrink Additional File Groups (applies only if using Netflow)

- Ensure the File Type is set to Data, Filegroup "FG1".

- For the Shrink Action, select "Reorganise pages before releasing unused space. Change the "Shrink File to" setting to just above the minimum setting shown on the right.

- Click OK. This can take a while - usually a few mins per GB.

- Repeat for each File group (FG1 to FG4)

Run database Maintenance from the Start menu, click Start > All Programs > SolarWinds Orion > Advanced Features > Database Maintenance, and then click Start

For me, with a 50G database, this took close to 2 hours.