Archive SharePoint on-premise content db on cloud

Jin T 96 Reputation points
2023-03-09T13:57:36.6666667+00:00

Hi All,

We have a SP 2010 on-premise environment which we plan to migrate to O365 using ShareGate but for various compliance, country data laws we need to preserve the data for 7 years.

Couple of queries:

  1. So is there a way to preserve SharePoint content db as is (we don't mind moving the db to Azure SQL or store the db file in blob), is this is a feasible and a good idea ? The 2010 environment would be decommissioned after migration but we want to preserver the content db for legal reasons.
  2. Another question, lets say we move the db to Azure SQL, if at any point in future we need to see the contents of the db, apart from the db view, how can the content be seen ?

Thanks in Advance.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,205 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,555 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,793 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 41,691 Reputation points Microsoft Vendor
    2023-03-10T07:58:14.1766667+00:00

    1.You can back up a content database by using the SharePoint Central Administration website, Microsoft PowerShell, or SQL Server tools.

    Reference: https://learn.microsoft.com/en-us/sharepoint/administration/back-up-a-content-database

    2.If you migrate SharePoint 2010 to Microsoft 365, you will see your contents in the SharePoint Online. You also could use the Azure portal query editor to query Azure SQL Database.

    Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal?view=azuresql


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.