Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Additional Database Storage Capacity

  • 1.  Additional Database Storage Capacity

    GOLD CONTRIBUTOR
    Posted Aug 05, 2020 01:18 PM
    I am over my limit of Database storage capacity, so I need to buy more.  However, we are going to be archiving a ton of emails in our PROD environment to get us back down to the allotted capacity after we do some testing in our sandbox.

    If I buy more capacity this month, can I reduce capacity in the future?

    ------------------------------
    Tina Silver
    Sr BSA, CSM®
    SR Smith, LLC
    Canby OR
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Additional Database Storage Capacity

    D365UG/CRMUG ALL STAR
    Posted Aug 05, 2020 02:17 PM
    Yes!

    ------------------------------
    Heidi Neuhauser
    Director, CRM Projects
    Reenhanced
    Green Lane PA
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Additional Database Storage Capacity

    D365UG/CRMUG ALL STAR
    Posted Aug 05, 2020 02:19 PM
    Sorry, I didn't mean to only reply with "Yes!" :)

    Here are some good suggestions on how to reduce storage space that might help you as well: https://docs.microsoft.com/en-us/power-platform/admin/free-storage-space

    Have you looked into any 3rd party solutions to help you manage attachments? I'm a fan of Attachment Extractor (from mscrm-addons) that will strip your attachment and move it into SharePoint (a much cheaper storage solution than D365).

    ------------------------------
    Heidi Neuhauser
    Director, CRM Projects
    Reenhanced
    Green Lane PA
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Additional Database Storage Capacity

    GOLD CONTRIBUTOR
    Posted Aug 05, 2020 02:32 PM
    Thanks, Heidi!

    We are currently storing our attachments in Azure, using a plugin that our previous partner suggested.  However, I feel that it might not be working as intended.  I reached out to Patrick (mscrm-addons) for the link to the webinar about the Attachment Extractor. I've passed that to my new consultant and Azure Admin to take a look.  The problem we have is that we would probably have to rebuild our current process and that is scary for our little organization.

    ------------------------------
    Tina Silver
    Sr BSA, CSM®
    SR Smith, LLC
    Canby OR
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Additional Database Storage Capacity

    SILVER CONTRIBUTOR
    Posted Aug 06, 2020 09:56 AM
    Hello friends,


    I'm not sure if you're aware of it, but there is a new storage capacity model where there are 3 categories of storage, Database, Files and Logs. Email Attachments will count against the File bucket instead of DB. I think in the background Dynamics would save these files to Azure. It is all in the license cost, not extra.

    ------------------------------
    Hasan Bazerbashi
    Sr. CRM/.NET Developer
    Cineplex Inc.
    Toronto ON
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Additional Database Storage Capacity

    TOP CONTRIBUTOR
    Posted Aug 06, 2020 06:10 PM
    Hasan,

    You raise a good point about the three categories of data storage.  Our AttachmentExtractor has always provided an easy way to move Note and Email attachments to SharePoint of the Azure Blob to reduce File storage.  And with our recent enhancement to move the email body from the ActivityPointerBase table to the Azure Blob, you can significantly reduce the Database storage as well.  (i.e. many see a 40 - 60% reduction in the ActivityPointer base table).  And we added this additional feature to our AttachmentExtractor add-on solution without any additional cost.

    This recorded webinar provides additional info on how this works and how to better determine if the combination of note and email attachments AND the email body extraction would help your organization save money on excess storage capacity charges:

    https://www.mscrm-addons.com/language/en-US/Support/Webinars/ArticleId/55/save-data-capacity-by-moving-e-mail-content-to-azure-blob-storage


    If you have any questions, feel free to reach out to me directly.

    ------------------------------
    Patrick O'Donnell | VP - Business Development, the Americas
    mscrm-addons.com
    Patrick.ODonnell@mscrm-addons.com
    Atlanta GA
    770 781 8260 Cell
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: Additional Database Storage Capacity

    TOP CONTRIBUTOR
    Posted Aug 05, 2020 03:06 PM
    Just in case you didn't already think of it, sometimes you can reduce the data you already have to get back down under your limit.  If you have auditing on, you might be able to eliminate some of the older audit logs.  If your sandbox is a copy of your production environment, you can use bulk delete to delete older records or records from entities which aren't currently being used - or wouldn't need to be used for testing.  And if you have auditing on in production and you've copied production to your sandbox, you can delete all the audit logs from the sandbox.

    ------------------------------
    Jill Vazquez
    Technical Specialist - CRM
    Bioventus, LLC
    Durham NC
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role