Currently this is the error I'm trying to resolve. At first I was getting missing SMO SQL component, but I installed SSMS 2017 on the CRM Web Server (which is not ideal - but this is a test system) and this fixed the issue. Now it's the autonumberformat issue with Attribute.
14:41:35|Verbose| UpdateRollupFieldStoredProceduresInternal Enter
14:41:36|Verbose| Error occured in UpdateRollupFieldStoredProceduresInternal: Microsoft.Crm.Metadata.MetadataAttributeMetadataNotFoundException: 'Attribute' metadata entity doesn't contain metadata attribute with Name = 'autonumberformat'.
at Microsoft.Crm.Metadata.MetadataAttributeInfoCollection.ThrowIfPropertyNameIsInvalid(String metadataAttributeName)
at Microsoft.Crm.Metadata.PropertyBagMetadataAttributeInfoCollection.get_Item(String name)
at Microsoft.Crm.Metadata.MetadataBusinessEntity.IsPropertyNull(String propertyName)
at Microsoft.Crm.Metadata.AttributeUpdateAction.HasStringFieldDefinitionChanged(MetadataBusinessEntity updateData, MetadataBusinessEntity oldData, String attributeName)
at Microsoft.Crm.Metadata.AttributeUpdateAction.UpdateAttributeTable()
at Microsoft.Crm.Metadata.AttributeUpdateAction.MetabaseOperation()
at Microsoft.Crm.Metadata.MetadataHelper.<>c__DisplayClass116_0.<ProcessQueue_metabaseActionsToExecute>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.Metadata.MetadataHelper.<ProcessQueue>b__110_0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.Metadata.AttributeService.UpdateSourceTypeMaskInDatabase(Guid attributeId, Int32 sourceTypeMask, ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.UpdateRollupFieldStoredProcedures.UpdateRollupFieldStoredProceduresInternal(ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.UpdateRollupFieldStoredProcedures.Execute()
14:41:36| Info| Action Bin\Microsoft.Crm.SE.DatabaseActions.dll:Execute with id a6651d68-65ef-4508-989a-04521fbe63d5 of type DllMethod to Update stored procedures for OOB and Custom Rollup fields failed on attempt 2. Retrying in 30 seconds. Exception: Exception has been thrown by the target of an invocation.